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_PREPAY_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

Line 1594: AP_invoice_payments_all AIP

1590: AC.exchange_rate_type,
1591: AC.exchange_date,
1592: AC.exchange_rate
1593: FROM AP_checks_all AC,
1594: AP_invoice_payments_all AIP
1595: WHERE AC.check_id = AIP.check_id
1596: AND AIP.invoice_id = CV_PPAY_Invoice_ID
1597: AND AIP.reversal_inv_pmt_id IS NULL -- bug8971713
1598: AND NOT EXISTS (SELECT 'Invoice payment has been reversed'

Line 1599: FROM AP_invoice_payments_all AIP2

1595: WHERE AC.check_id = AIP.check_id
1596: AND AIP.invoice_id = CV_PPAY_Invoice_ID
1597: AND AIP.reversal_inv_pmt_id IS NULL -- bug8971713
1598: AND NOT EXISTS (SELECT 'Invoice payment has been reversed'
1599: FROM AP_invoice_payments_all AIP2
1600: WHERE AIP2.reversal_inv_pmt_id = AIP.invoice_payment_id
1601: AND AIP2.check_id = AC.check_id);
1602:
1603: CURSOR C_PPAY_DIST_INFO (CV_PPAY_Invoice_ID IN NUMBER,