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