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

Line 889: FROM ap_inv_selection_criteria_all ap

885: );
886:
887: SELECT count(*)
888: INTO l_count2
889: FROM ap_inv_selection_criteria_all ap
890: WHERE ap.status IN ('REVIEW', 'MISSING RATES' )
891: AND NOT EXISTS ( SELECT 'NEED_ACTION_BY_ME'
892: FROM iby_pay_service_requests iby
893: WHERE iby.calling_app_id = 200

Line 951: FROM ap_inv_selection_criteria_all ap

947:
948:
949: SELECT count(*)
950: INTO l_count2
951: FROM ap_inv_selection_criteria_all ap
952: WHERE ap.status IN ('UNSTARTED', 'SELECTING', 'CANCELING',
953: 'CALCULATING', 'SELECTED')
954: AND NOT EXISTS ( SELECT 'PROCESSING'
955: FROM iby_pay_service_requests iby

Line 966: FROM ap_inv_selection_criteria_all ap

962:
963: ELSIF p_snapshot_code = 'USER_TERMINATED' THEN
964: SELECT count(*)
965: INTO l_count1
966: FROM ap_inv_selection_criteria_all ap
967: WHERE EXISTS ( SELECT 'IBY USER_TERMINATED'
968: FROM iby_pay_service_requests iby
969: WHERE iby.calling_app_id = 200
970: AND iby.call_app_pay_service_req_code =

Line 978: FROM ap_inv_selection_criteria_all ap

974: AND ap.creation_date BETWEEN TRUNC(SYSDATE) AND (TRUNC(SYSDATE) + 0.99999);
975:
976: SELECT count(*)
977: INTO l_count2
978: FROM ap_inv_selection_criteria_all ap
979: WHERE ap.status IN ('CANCELED', 'CANCELLED NO PAYMENTS')
980: AND TRUNC(ap.creation_date) =TRUNC(sysdate)
981: AND NOT EXISTS ( SELECT 'AP USER_TERMINATED'
982: FROM iby_pay_service_requests iby

Line 995: FROM ap_inv_selection_criteria_all ap

991: ELSIF p_snapshot_code = 'PROGRAM_ERRORS' THEN
992:
993: SELECT count(*)
994: INTO l_count1
995: FROM ap_inv_selection_criteria_all ap
996: WHERE EXISTS ( SELECT 'PROGRAM ERRORS'
997: FROM iby_pay_service_requests iby
998: WHERE iby.calling_app_id = 200
999: AND iby.call_app_pay_service_req_code =

Line 1013: FROM ap_inv_selection_criteria_all ap

1009: ELSIF p_snapshot_code = 'COMPLETED' THEN
1010:
1011: SELECT count(*)
1012: INTO l_count1
1013: FROM ap_inv_selection_criteria_all ap
1014: WHERE EXISTS ( SELECT 'COMPLETED'
1015: FROM iby_pay_service_requests iby
1016: WHERE iby.calling_app_id = 200
1017: AND iby.call_app_pay_service_req_code =

Line 1420: ap_inv_selection_criteria_all aisc

1416: aisc.checkrun_id ,
1417: aisc.checkrun_name ,
1418: aisc.creation_date
1419: FROM iby_pay_service_requests ipsr ,
1420: ap_inv_selection_criteria_all aisc
1421: WHERE ipsr.call_app_pay_service_req_code(+) = aisc.checkrun_name;
1422: --AND process_type = 'STANDARD' ;
1423: BEGIN
1424: IF(g_psr_snapshot_table.EXISTS(p_snapshot_code) AND g_psr_snapshot_table(p_snapshot_code).psr_snapshot_count IS NOT NULL) THEN

Line 1444: --For records in ap_inv_selection_criteria_all but not in iby_pay_service_request. For PPR which are still before build.

1440: --Handling everything with iby_pay_service_requests first.
1441: --For IBY_PAY_SERVICE_REQUESTS.
1442: IF c_rec_snap.payment_service_request_status IN ('INFORMATION_REQUIRED' , 'PENDING_REVIEW_DOC_VAL_ERRORS','PENDING_REVIEW_PMT_VAL_ERRORS', 'PENDING_REVIEW') THEN
1443: l_need_action := l_need_action + 1;
1444: --For records in ap_inv_selection_criteria_all but not in iby_pay_service_request. For PPR which are still before build.
1445: ELSIF c_rec_snap.payment_service_request_status IS NULL AND c_rec_snap.status IN ('REVIEW', 'MISSING RATES' ) THEN
1446: l_need_action := l_need_action + 1;
1447: /* IBY NEED ACTION */
1448: /* IBY IN PROCESS. */

Line 1705: FROM ap_inv_selection_criteria_all ap

1701: SELECT null,
1702: ap.checkrun_id,
1703: ap.checkrun_name,
1704: 'NEED_ACTION_BY_ME'
1705: FROM ap_inv_selection_criteria_all ap
1706: WHERE ap.status IN ('REVIEW', 'MISSING RATES' )
1707: AND NOT EXISTS ( SELECT 'NEED_ACTION_BY_ME'
1708: FROM iby_pay_service_requests iby
1709: WHERE iby.calling_app_id = 200

Line 1780: FROM ap_inv_selection_criteria_all ap

1776: SELECT null,
1777: ap.checkrun_id,
1778: ap.checkrun_name,
1779: 'PROCESSING'
1780: FROM ap_inv_selection_criteria_all ap
1781: WHERE ap.status IN ('UNSTARTED', 'SELECTING', 'CANCELING',
1782: 'CALCULATING', 'SELECTED')
1783: AND NOT EXISTS ( SELECT 'PROCESSING'
1784: FROM iby_pay_service_requests iby

Line 1804: FROM ap_inv_selection_criteria_all ap

1800: SELECT null,
1801: ap.checkrun_id,
1802: ap.checkrun_name,
1803: 'USER_TERMINATED'
1804: FROM ap_inv_selection_criteria_all ap
1805: WHERE EXISTS ( SELECT 'IBY USER_TERMINATED'
1806: FROM iby_pay_service_requests iby
1807: WHERE iby.calling_app_id = 200
1808: AND iby.call_app_pay_service_req_code =

Line 1822: FROM ap_inv_selection_criteria_all ap

1818: SELECT null,
1819: ap.checkrun_id,
1820: ap.checkrun_name,
1821: 'USER_TERMINATED'
1822: FROM ap_inv_selection_criteria_all ap
1823: WHERE ap.status IN ('CANCELED', 'CANCELLED NO PAYMENTS')
1824: AND TRUNC(ap.creation_date) =TRUNC(sysdate)
1825: AND NOT EXISTS ( SELECT 'AP USER_TERMINATED'
1826: FROM iby_pay_service_requests iby

Line 1849: FROM ap_inv_selection_criteria_all ap

1845: SELECT null,
1846: ap.checkrun_id,
1847: ap.checkrun_name,
1848: 'PROGRAM_ERRORS'
1849: FROM ap_inv_selection_criteria_all ap
1850: WHERE EXISTS ( SELECT 'PROGRAM ERRORS'
1851: FROM iby_pay_service_requests iby
1852: WHERE iby.calling_app_id = 200
1853: AND iby.call_app_pay_service_req_code =

Line 1876: FROM ap_inv_selection_criteria_all ap

1872: SELECT null,
1873: ap.checkrun_id,
1874: ap.checkrun_name,
1875: 'COMPLETED'
1876: FROM ap_inv_selection_criteria_all ap
1877: WHERE EXISTS ( SELECT 'COMPLETED'
1878: FROM iby_pay_service_requests iby
1879: WHERE iby.calling_app_id = 200
1880: AND iby.call_app_pay_service_req_code =