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 390: iby_payments_all IPA

386: SELECT ACA.check_id,
387: b.PAYMENT_INSTRUCTION_ID
388: FROM AP_CHECKS_all ACA,
389: iby_pay_instructions_all B,
390: iby_payments_all IPA
391: WHERE ACA.PAYMENT_INSTRUCTION_ID = b.PAYMENT_INSTRUCTION_ID AND
392: b.rowid = trx_rowid
393: AND nvl(ACA.status_lookup_code, 'NEGOTIABLE') <> 'VOIDED'
394: AND IPA.PAYMENT_INSTRUCTION_ID = b.PAYMENT_INSTRUCTION_ID

Line 407: FROM iby_payments_all IPA ,AP_CHECKS_ALL ACA

403: WHERE batch_id = X_batch_id
404: AND nvl(status, 'NEGOTIABLE') <> 'VOIDED'
405: AND application_id = 200
406: AND EXISTS ( SELECT 1
407: FROM iby_payments_all IPA ,AP_CHECKS_ALL ACA
408: WHERE ACA.CHECK_ID =catv.trx_id
409: AND ACA.PAYMENT_INSTRUCTION_ID = X_batch_id
410: AND IPA.PAYMENT_INSTRUCTION_ID = X_batch_id
411: AND IPA.PAYMENT_ID = ACA.PAYMENT_ID

Line 3044: FROM iby_payments_all IPA ,AP_CHECKS_ALL ACA

3040: AND nvl(catv.status, 'NEGOTIABLE') <> 'VOIDED'
3041: AND catv.application_id = 200
3042: AND NVL(catv.reconciled_status_flag, 'N') = 'N'
3043: AND EXISTS ( SELECT 1
3044: FROM iby_payments_all IPA ,AP_CHECKS_ALL ACA
3045: WHERE ACA.CHECK_ID =catv.trx_id
3046: AND ACA.PAYMENT_INSTRUCTION_ID = CE_AUTO_BANK_MATCH.trx_id
3047: AND IPA.PAYMENT_INSTRUCTION_ID = CE_AUTO_BANK_MATCH.trx_id
3048: AND IPA.PAYMENT_ID = ACA.PAYMENT_ID