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.AP_APXTRSWP_XMLP_PKG dependencies on AP_INV_SELECTION_CRITERIA_ALL

Line 413: FROM ap_inv_selection_criteria_all

409: BEGIN
410:
411: SELECT COUNT(*)
412: INTO cpb_counter
413: FROM ap_inv_selection_criteria_all
414: WHERE check_date BETWEEN p_start_date AND p_end_date
415: AND status NOT IN ('CONFIRMED', 'CANCELED', 'QUICKCHECK')
416: AND org_id = co_org_id
417: AND rownum = 1;

Line 1093: FROM ap_inv_selection_criteria_all

1089: AND rownum = 1;
1090:
1091: SELECT COUNT(*)
1092: INTO cpb_counter
1093: FROM ap_inv_selection_criteria_all
1094: WHERE check_date BETWEEN p_start_date AND p_end_date
1095: AND status NOT IN ('CONFIRMED', 'CANCELED', 'QUICKCHECK')
1096: AND org_id = co_org_id
1097: AND rownum = 1;

Line 1289: FROM ap_inv_selection_criteria_all AIS, hr_operating_units HOU

1285: AND rownum = 1;
1286:
1287: SELECT COUNT(*)
1288: INTO cpb_counter
1289: FROM ap_inv_selection_criteria_all AIS, hr_operating_units HOU
1290: WHERE AIS.org_id = HOU.organization_id
1291: AND AIS.check_date BETWEEN p_start_date AND p_end_date
1292: AND status NOT IN ('CONFIRMED', 'CANCELED', 'QUICKCHECK')
1293: AND HOU.set_of_books_id = to_char(p_set_of_books_id) --Bug 2986690