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 STANDARD

Line 862: AND iby.process_type = 'STANDARD'

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
865: SELECT COUNT(*) icount
866: FROM iby_pay_service_requests iby

Line 868: AND iby.process_type = 'STANDARD'

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
871: (SELECT 'NEED_ACTION_BY_ME'
872: FROM iby_payments_all pmt

Line 910: AND iby.process_type = 'STANDARD'

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: (
913: iby.payment_service_request_status IN ('INSERTED', 'SUBMITTED',
914: 'ASSIGNMENT_COMPLETE',

Line 1422: --AND process_type = 'STANDARD' ;

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
1425:
1426: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1670: AND iby.process_type = 'STANDARD'

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
1673: SELECT iby.payment_service_request_id,
1674: null,

Line 1679: AND iby.process_type = 'STANDARD'

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
1682: (SELECT 'NEED_ACTION_BY_ME'
1683: FROM iby_payments_all pmt

Line 1733: AND iby.process_type = 'STANDARD'

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: (
1736: iby.payment_service_request_status IN ('INSERTED', 'SUBMITTED',
1737: 'ASSIGNMENT_COMPLETE',