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.

[Home] [Help]

APPS.JG_ZZ_SUMMARY_AP_PKG dependencies on AP_PAYMENT_SCHEDULES_ALL

Line 41: ,ap_payment_schedules_all APS

37: SELECT nvl(SUM(amount_remaining), -9999) amount_remaining
38: FROM ap_invoices_all INV
39: ,ap_invoice_payments_all PAY
40: ,ap_checks_all CHECKS
41: ,ap_payment_schedules_all APS
42: WHERE APS.invoice_id = inv.invoice_id
43: AND inv.invoice_id = pay.invoice_id
44: AND checks.check_id = pay.check_id
45: AND pn_inv_id = inv.invoice_id

Line 1159: ap_payment_schedules_all APS

1155: l_unpaid_amt_select := 'AND (SELECT nvl(sum(amount_remaining),99999)
1156: FROM ap_invoices_all INV,
1157: ap_invoice_payments_all PAY,
1158: ap_checks_all CHECKS,
1159: ap_payment_schedules_all APS
1160: WHERE APS.invoice_id = inv.invoice_id
1161: AND inv.invoice_id = pay.invoice_id
1162: AND checks.check_id = pay.check_id
1163: AND jg_info_n5 = inv.invoice_id