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 1144: FROM ap_invoices_all INV, ap_invoice_payments_all PAY, ap_checks_all CHECKS

1140:
1141: -- Exclude paid transactions for the
1142: -- Annex Report
1143: l_cleared_select := '(SELECT NVL((SELECT NVL(SUM(pay.payment_base_amount),0)
1144: FROM ap_invoices_all INV, ap_invoice_payments_all PAY, ap_checks_all CHECKS
1145: WHERE inv.invoice_id = pay.invoice_id
1146: AND checks.check_id = pay.check_id
1147: AND jg_info_n5 = inv.invoice_id
1148: AND checks.status_lookup_code IN ( ''CLEARED'' , ''RECONCILED'' , ''CLEARED BUT UNACCOUNTED'', ''RECONCILED UNACCOUNTED'' )';

Line 1158: ap_checks_all CHECKS,

1154:
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