DBA Data[Home] [Help]

APPS.JE_ZZ_AUDIT_AP_PKG dependencies on AP_CHECKS

Line 125: ,ap_checks chk

121: ,zx_rates_b tax
122: ,ap_invoice_distributions item
123: ,ap_invoices pp
124: ,ap_invoice_distributions ppdis
125: ,ap_checks chk
126: ,ap_invoice_payments aip
127: ,ap_invoice_lines apl
128: ,zx_lines zl
129: ,zx_lines_det_factors zldf

Line 862: ap_checks_all chk,

858: ap_invoices inv,
859: ap_invoice_distributions dis,
860: po_vendors ven,
861: ap_invoice_payments aip,
862: ap_checks_all chk,
863: ap_invoice_distributions acctinfo
864: WHERE ((p_ledger_id IS NULL
865: AND p_company IS NULL
866: AND inv.legal_entity_id = g_le_id) OR(p_ledger_id IS NOT NULL

Line 2028: ,ap_checks chk

2024: ,p_end_date DATE)
2025: IS
2026: SELECT SUM(nvl(disc.discount_taken, 0)) discount_taken
2027: FROM ap_invoice_payments disc
2028: ,ap_checks chk
2029: WHERE disc.invoice_id = p_invoice_id
2030: AND disc.check_id = chk.check_id
2031: AND nvl(chk.future_pay_due_date, chk.check_date) BETWEEN
2032: p_start_date AND p_end_date;