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.AP_PMT_CALLOUT_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 3222: ap_invoice_distributions_all aid,

3218:
3219: SELECT COUNT(*) INTO l_prepay_app_exists
3220: FROM ap_checks_all ac,
3221: ap_invoice_payments_all aip,
3222: ap_invoice_distributions_all aid,
3223: ap_invoices_all ai
3224: WHERE ac.payment_id = p_payment_id
3225: AND ac.check_id = aip.check_id
3226: AND aip.invoice_id = ai.invoice_id

Line 3247: FROM ap_invoice_distributions_all aid_prepay,

3243: INTO l_check_prepay_unapply
3244: FROM dual
3245: WHERE EXISTS
3246: (SELECT 1
3247: FROM ap_invoice_distributions_all aid_prepay,
3248: ap_checks_all ac,
3249: ap_invoice_payments_all aip,
3250: ap_invoices_all ai_prepay,
3251: ap_invoice_distributions_all aid,

Line 3251: ap_invoice_distributions_all aid,

3247: FROM ap_invoice_distributions_all aid_prepay,
3248: ap_checks_all ac,
3249: ap_invoice_payments_all aip,
3250: ap_invoices_all ai_prepay,
3251: ap_invoice_distributions_all aid,
3252: ap_invoice_distributions_all aidp
3253: WHERE aip.check_id = ac.check_id
3254: AND ac.payment_id = p_payment_id
3255: AND aip.invoice_id = ai_prepay.invoice_id

Line 3252: ap_invoice_distributions_all aidp

3248: ap_checks_all ac,
3249: ap_invoice_payments_all aip,
3250: ap_invoices_all ai_prepay,
3251: ap_invoice_distributions_all aid,
3252: ap_invoice_distributions_all aidp
3253: WHERE aip.check_id = ac.check_id
3254: AND ac.payment_id = p_payment_id
3255: AND aip.invoice_id = ai_prepay.invoice_id
3256: AND ai_prepay.invoice_type_lookup_code = 'PREPAYMENT'