Oracle apps query to find approval limits

By admin

Oracle apps query to find approval limits
Purchase requisition approval limits query in R12
Purchasing approval limits in Oracle EBS
approval limits in oracle purchasing
r12 approval limits query

SQL Querysql
1--approval limits
2SELECT d.full_name,
3       e.job_id,
4       g.control_group_name,
5       h.object_code,
6       h.amount_limit,
7       h.*
8  FROM per_all_people_f          d,
9       per_all_assignments_f     e,
10       po_position_controls_all  f,
11       po_control_groups_all     g,
12       po_control_rules          h,
13       apps.po_control_functions pcf
14 WHERE     1 = 1
15       AND d.effective_end_date > SYSDATE
16       AND d.person_id = e.person_id
17       AND e.effective_end_date > SYSDATE
18       AND e.job_id = f.job_id
19       AND f.control_group_id = g.control_group_id
20       AND g.control_group_id = h.control_group_id
21       AND pcf.control_function_name = 'Approve Purchase Requisitions'  -- change the function name according to module
22       AND f.control_function_id = pcf.control_function_id
23       AND g.org_id = 123  --enter operating unit org_id
24       AND d.person_id = 878787; --enter person_id from per_all_people_f