Query to find all Expense report entry delegations

By admin

Query to find all Expense report entry delegations
Oracle apps expense report entry delegation setup details oracle apps EBS
Expense report entry delegation audit query in R12
oracle cloud expense report delegation

SQL Querysql
1--Query to find all Expense report entry delegations(unimportant columns are commented)
2  SELECT -- dsa.web_user_id,
3         -- dsa.attribute_code,
4         -- dsa.attribute_application_id,
5         -- dsa.varchar2_value,
6         -- dsa.date_value,
7         -- dsa.number_value,
8         -- dsa.created_by,
9         -- dsa.creation_date,
10         -- dsa.last_updated_by,
11         -- dsa.last_update_date,
12         -- dsa.last_update_login,
13         emp.user_name employee, usr.user_name delegate
14    -- ap_web_audit_utils.get_employee_info(usr.employee_id, 'full_name', 'VARCHAR2') employee_name,
15    -- ap_web_audit_utils.get_employee_info(usr.employee_id, 'full_name', 'VARCHAR2') employee_name_ro
16    FROM apps.ak_web_user_sec_attr_values dsa,
17         apps.fnd_user                  usr,
18         apps.fnd_user                  emp
19   WHERE     1 = 1
20         -- dsa.web_user_id 1
21         -- AND dsa.number_value = 2
22         AND dsa.attribute_code = 'ICX_HR_PERSON_ID'
23         AND dsa.attribute_application_id = 178
24         AND usr.user_id = dsa.web_user_id
25         AND emp.user_name != usr.user_name
26         AND SYSDATE BETWEEN usr.start_date AND NVL (usr.end_date, SYSDATE + 1)
27         AND emp.employee_id = dsa.number_value
28         AND SYSDATE BETWEEN emp.start_date AND NVL (emp.end_date, SYSDATE + 1)
29ORDER BY usr.user_name;