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 IBY_PAY_SERVICE_REQUESTS

Line 860: FROM iby_pay_service_requests iby

856: SELECT SUM(icount) tcount
857: INTO l_count1
858: FROM
859: (SELECT COUNT(*) icount
860: FROM iby_pay_service_requests iby
861: WHERE iby.calling_app_id = 200
862: AND iby.process_type = 'STANDARD'
863: AND iby.payment_service_request_status IN ( 'INFORMATION_REQUIRED', 'PENDING_REVIEW_DOC_VAL_ERRORS', 'PENDING_REVIEW_PMT_VAL_ERRORS', 'PENDING_REVIEW')
864: UNION

Line 866: FROM iby_pay_service_requests iby

862: AND iby.process_type = 'STANDARD'
863: AND iby.payment_service_request_status IN ( 'INFORMATION_REQUIRED', 'PENDING_REVIEW_DOC_VAL_ERRORS', 'PENDING_REVIEW_PMT_VAL_ERRORS', 'PENDING_REVIEW')
864: UNION
865: SELECT COUNT(*) icount
866: FROM iby_pay_service_requests iby
867: WHERE iby.calling_app_id = 200
868: AND iby.process_type = 'STANDARD'
869: AND iby.payment_service_request_status = 'PAYMENTS_CREATED'
870: AND EXISTS

Line 892: FROM iby_pay_service_requests iby

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
894: AND iby.call_app_pay_service_req_code =
895: ap.checkrun_name);
896:

Line 908: FROM iby_pay_service_requests iby

904: are waiting for the user action*/
905: SELECT
906: count(*)
907: INTO l_count1
908: FROM iby_pay_service_requests iby
909: WHERE iby.calling_app_id = 200
910: AND iby.process_type = 'STANDARD'
911: AND
912: (

Line 955: FROM iby_pay_service_requests iby

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
956: WHERE iby.calling_app_id = 200
957: AND iby.call_app_pay_service_req_code =
958: ap.checkrun_name);
959:

Line 968: FROM iby_pay_service_requests iby

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 =
971: ap.checkrun_name
972: AND iby.payment_service_request_status IN

Line 982: FROM iby_pay_service_requests iby

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
983: WHERE iby.calling_app_id = 200
984: AND iby.call_app_pay_service_req_code =
985: ap.checkrun_name)
986: AND ap.creation_date BETWEEN TRUNC(SYSDATE) AND (TRUNC(SYSDATE) + 0.99999);

Line 997: FROM iby_pay_service_requests iby

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 =
1000: ap.checkrun_name
1001: AND iby.payment_service_request_status IN

Line 1015: FROM iby_pay_service_requests iby

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 =
1018: ap.checkrun_name
1019: AND iby.payment_service_request_status IN

Line 1419: FROM iby_pay_service_requests ipsr ,

1415: aisc.status ,
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

Line 1440: --Handling everything with iby_pay_service_requests first.

1436: FOR c_rec_snap IN c_psr_snapshot
1437: LOOP
1438:
1439: /* IBY NEED ACTION */
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.

Line 1441: --For IBY_PAY_SERVICE_REQUESTS.

1437: LOOP
1438:
1439: /* IBY NEED ACTION */
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

Line 1668: FROM iby_pay_service_requests iby

1664: SELECT iby.payment_service_request_id,
1665: null,
1666: iby.CALL_APP_PAY_SERVICE_REQ_CODE,
1667: 'NEED_ACTION_BY_ME'
1668: FROM iby_pay_service_requests iby
1669: WHERE iby.calling_app_id = 200
1670: AND iby.process_type = 'STANDARD'
1671: AND iby.payment_service_request_status IN ( 'INFORMATION_REQUIRED', 'PENDING_REVIEW_DOC_VAL_ERRORS', 'PENDING_REVIEW_PMT_VAL_ERRORS', 'PENDING_REVIEW')
1672: UNION

Line 1677: FROM iby_pay_service_requests iby

1673: SELECT iby.payment_service_request_id,
1674: null,
1675: iby.CALL_APP_PAY_SERVICE_REQ_CODE,
1676: 'NEED_ACTION_BY_ME'
1677: FROM iby_pay_service_requests iby
1678: WHERE iby.calling_app_id = 200
1679: AND iby.process_type = 'STANDARD'
1680: AND iby.payment_service_request_status = 'PAYMENTS_CREATED'
1681: AND EXISTS

Line 1708: FROM iby_pay_service_requests iby

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
1710: AND iby.call_app_pay_service_req_code =
1711: ap.checkrun_name);
1712:

Line 1731: FROM iby_pay_service_requests iby

1727: SELECT iby.payment_service_request_id,
1728: null,
1729: iby.CALL_APP_PAY_SERVICE_REQ_CODE,
1730: 'PROCESSING'
1731: FROM iby_pay_service_requests iby
1732: WHERE iby.calling_app_id = 200
1733: AND iby.process_type = 'STANDARD'
1734: AND
1735: (

Line 1784: FROM iby_pay_service_requests iby

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
1785: WHERE iby.calling_app_id = 200
1786: AND iby.call_app_pay_service_req_code =
1787: ap.checkrun_name);
1788:

Line 1806: FROM iby_pay_service_requests iby

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 =
1809: ap.checkrun_name
1810: AND iby.payment_service_request_status IN

Line 1826: FROM iby_pay_service_requests iby

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
1827: WHERE iby.calling_app_id = 200
1828: AND iby.call_app_pay_service_req_code =
1829: ap.checkrun_name)
1830: AND ap.creation_date BETWEEN TRUNC(SYSDATE) AND (TRUNC(SYSDATE) + 0.99999);

Line 1851: FROM iby_pay_service_requests iby

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 =
1854: ap.checkrun_name
1855: AND iby.payment_service_request_status IN

Line 1878: FROM iby_pay_service_requests iby

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 =
1881: ap.checkrun_name
1882: AND iby.payment_service_request_status IN