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_MATCH dependencies on IBY_PAYMENTS_ALL

Line 371: iby_payments_all IPA

367: SELECT ACA.check_id,
368: b.PAYMENT_INSTRUCTION_ID
369: FROM AP_CHECKS_all ACA,
370: iby_pay_instructions_all B,
371: iby_payments_all IPA
372: WHERE ACA.PAYMENT_INSTRUCTION_ID = b.PAYMENT_INSTRUCTION_ID AND
373: b.rowid = trx_rowid
374: AND nvl(ACA.status_lookup_code, 'NEGOTIABLE') <> 'VOIDED'
375: AND IPA.PAYMENT_INSTRUCTION_ID = b.PAYMENT_INSTRUCTION_ID

Line 388: FROM iby_payments_all IPA ,AP_CHECKS_ALL ACA

384: WHERE batch_id = X_batch_id
385: AND nvl(status, 'NEGOTIABLE') <> 'VOIDED'
386: AND application_id = 200
387: AND EXISTS ( SELECT 1
388: FROM iby_payments_all IPA ,AP_CHECKS_ALL ACA
389: WHERE ACA.CHECK_ID =catv.trx_id
390: AND ACA.PAYMENT_INSTRUCTION_ID = X_batch_id
391: AND IPA.PAYMENT_INSTRUCTION_ID = X_batch_id
392: AND IPA.PAYMENT_ID = ACA.PAYMENT_ID

Line 3110: FROM iby_payments_all IPA ,AP_CHECKS_ALL ACA

3106: AND nvl(catv.status, 'NEGOTIABLE') <> 'VOIDED'
3107: AND catv.application_id = 200
3108: AND NVL(catv.reconciled_status_flag, 'N') = 'N'
3109: AND EXISTS ( SELECT 1
3110: FROM iby_payments_all IPA ,AP_CHECKS_ALL ACA
3111: WHERE ACA.CHECK_ID =catv.trx_id
3112: AND ACA.PAYMENT_INSTRUCTION_ID = CE_AUTO_BANK_MATCH.trx_id
3113: AND IPA.PAYMENT_INSTRUCTION_ID = CE_AUTO_BANK_MATCH.trx_id
3114: AND IPA.PAYMENT_ID = ACA.PAYMENT_ID