APPS.JG_ZZ_SUMMARY_AP_PKG dependencies on AP_CHECKS_ALL

Line 40: ,ap_checks_all CHECKS

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
44: AND checks.check_id = pay.check_id

Line 68: ,ap_checks_all CHECKS

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
72: AND checks.status_lookup_code IN ('CLEARED', 'RECONCILED','CLEARED BUT UNACCOUNTED', 'RECONCILED UNACCOUNTED')

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 1757: ap_checks_all CHECKS,

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
1761: AND checks.check_id = pay.check_id