APPS.JG_ZZ_SUMMARY_AP_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

Line 39: ,ap_invoice_payments_all PAY

35: CURSOR c_amount_remaining
36: IS
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

Line 67: ,ap_invoice_payments_all PAY

63: CURSOR c_cleared_amount
64: IS
65: SELECT NVL(SUM(checks.amount),0)
66: FROM ap_invoices_all INV
67: ,ap_invoice_payments_all PAY
68: ,ap_checks_all CHECKS
69: WHERE pn_inv_id = inv.invoice_id
70: AND checks.check_id = pay.check_id
71: AND inv.invoice_id = pay.invoice_id

Line 1743: FROM ap_invoices_all INV, ap_invoice_payments_all PAY, ap_checks_all CHECKS

1739:
1740: -- Exclude paid transactions for the
1741: -- Annex Report
1742: l_cleared_select := '(SELECT NVL((SELECT NVL(SUM(pay.payment_base_amount),0)
1743: FROM ap_invoices_all INV, ap_invoice_payments_all PAY, ap_checks_all CHECKS
1744: WHERE inv.invoice_id = pay.invoice_id
1745: AND checks.check_id = pay.check_id
1746: AND jg_info_n5 = inv.invoice_id
1747: AND checks.status_lookup_code IN ( ''CLEARED'' , ''RECONCILED'' , ''CLEARED BUT UNACCOUNTED'', ''RECONCILED UNACCOUNTED'' )';

Line 1756: ap_invoice_payments_all PAY,

1752: WHERE jg_info_n5 = inv1.invoice_id ),0) from dual )';
1753:
1754: l_unpaid_amt_select := 'AND (SELECT nvl(sum(amount_remaining),99999)
1755: FROM ap_invoices_all INV,
1756: ap_invoice_payments_all PAY,
1757: ap_checks_all CHECKS,
1758: ap_payment_schedules_all APS
1759: WHERE APS.invoice_id = inv.invoice_id
1760: AND inv.invoice_id = pay.invoice_id