eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_DOCUMENT_ACTION_CHECK dependencies on PO_CONTROL_RULES

Line 1075: FROM po_control_rules pocr

1071:
1072:
1073: SELECT sign(min(nvl(POCR.amount_limit, l_amt_limit_nvl) - sum(pgt.num1)))
1074: INTO l_result
1075: FROM po_control_rules pocr
1076: , po_control_groups pocg
1077: , po_position_controls popc
1078: , po_session_gt pgt
1079: WHERE pgt.key = p_session_gt_key

Line 1177: FROM po_control_rules pocr

1173: END IF;
1174:
1175: SELECT sign(min(nvl(POCR.amount_limit, -1) - sum(pgt.num1)))
1176: INTO l_result
1177: FROM po_control_rules pocr
1178: , po_control_groups pocg
1179: , po_position_controls popc
1180: , po_session_gt pgt
1181: WHERE pgt.key = p_session_gt_key

Line 1826: -- 5 - object code in po_control_rules, e.g. 'ACCOUNT_RANGE'

1822: -- 1 - key into po_session_gt table
1823: -- 2 - p_auth_check_ids.position_id
1824: -- 3 - p_auth_check_ids.job_id
1825: -- 4 - p_auth_check_ids.ctl_function_id
1826: -- 5 - object code in po_control_rules, e.g. 'ACCOUNT_RANGE'
1827:
1828: x_range_check_sql := 'SELECT sign(min(nvl(POCR.amount_limit, -1) '
1829: || ' - sum(' || l_sum_col || ')))'
1830: || ' FROM po_session_gt pgt, po_control_rules pocr'

Line 1830: || ' FROM po_session_gt pgt, po_control_rules pocr'

1826: -- 5 - object code in po_control_rules, e.g. 'ACCOUNT_RANGE'
1827:
1828: x_range_check_sql := 'SELECT sign(min(nvl(POCR.amount_limit, -1) '
1829: || ' - sum(' || l_sum_col || ')))'
1830: || ' FROM po_session_gt pgt, po_control_rules pocr'
1831: || ' , po_control_groups pocg, po_position_controls popc'
1832: || l_flex_table
1833: || ' WHERE pgt.key = :1 AND ' || l_sum_col || ' IS NOT NULL'
1834: || ' AND pgt.char1 = ''N'' '

Line 1973: -- 5 - object code in po_control_rules, e.g. 'ACCOUNT_RANGE'

1969: -- 1 - key into po_session_gt table
1970: -- 2 - p_auth_check_ids.position_id
1971: -- 3 - p_auth_check_ids.job_id
1972: -- 4 - p_auth_check_ids.ctl_function_id
1973: -- 5 - object code in po_control_rules, e.g. 'ACCOUNT_RANGE'
1974:
1975: x_range_check_sql := 'SELECT nvl(min(-1),0) '
1976: || ' FROM po_session_gt pgt '
1977: || l_flex_table

Line 1982: || ' FROM po_control_rules pocr, po_control_groups pocg'

1978: || ' WHERE pgt.key = :1 '
1979: || l_flex_join
1980: || ' AND NOT EXISTS ( '
1981: || ' SELECT ''account is in range'' '
1982: || ' FROM po_control_rules pocr, po_control_groups pocg'
1983: || ' , po_position_controls popc '
1984: --
1985: || ' WHERE ((:2 IS NULL) OR (popc.position_id = :3))'
1986: || ' AND ((:4 IS NULL) OR (popc.job_id = :5))'