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.CE_AUTO_BANK_CLEAR1 dependencies on IBY_PAYMENTS_ALL

Line 60: FROM iby_payments_all IPA ,AP_CHECKS_ALL ACA

56: AND nvl(a.status, 'NEGOTIABLE') <> 'VOIDED'
57: AND a.application_id = 200
58: AND NVL(a.reconciled_status_flag, 'N') = 'N'
59: AND EXISTS ( SELECT 1
60: FROM iby_payments_all IPA ,AP_CHECKS_ALL ACA
61: WHERE ACA.CHECK_ID =a.trx_id
62: AND ACA.PAYMENT_INSTRUCTION_ID = pbatch_id
63: AND IPA.PAYMENT_INSTRUCTION_ID (+) = pbatch_id -- Bug # 8353600 Added Outer Join (+)
64: AND IPA.PAYMENT_ID (+) = ACA.PAYMENT_ID -- Bug # 8353600 Added Outer Join (+)

Line 95: FROM iby_payments_all IPA ,AP_CHECKS_ALL ACA

91: WHERE a.batch_id = pbatch_id
92: AND nvl(a.status, 'NEGOTIABLE') <> 'VOIDED'
93: -- FOR SEPA ER 6700007
94: AND EXISTS ( SELECT 1
95: FROM iby_payments_all IPA ,AP_CHECKS_ALL ACA
96: WHERE ACA.CHECK_ID =a.trx_id
97: AND ACA.PAYMENT_INSTRUCTION_ID = pbatch_id
98: AND IPA.PAYMENT_INSTRUCTION_ID (+) = pbatch_id -- Bug # 8353600 Added Outer Join (+)
99: AND IPA.PAYMENT_ID (+) = ACA.PAYMENT_ID -- Bug # 8353600 Added Outer Join (+)