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 894: ap_checks_all chk,

890: ap_invoices inv,
891: ap_invoice_distributions dis,
892: po_vendors ven,
893: ap_invoice_payments aip,
894: ap_checks_all chk,
895: ap_invoice_distributions acctinfo,
896: zx_rec_nrec_dist zl LEFT OUTER JOIN zx_accounts ACCOUNTS
897: ON (accounts.TAX_ACCOUNT_ENTITY_ID =
898: nvl(zl.ACCOUNT_SOURCE_TAX_RATE_ID, zl.TAX_RATE_ID)

Line 2131: ,ap_checks chk

2127: ,p_end_date DATE)
2128: IS
2129: SELECT SUM(nvl(disc.discount_taken, 0)) discount_taken
2130: FROM ap_invoice_payments disc
2131: ,ap_checks chk
2132: WHERE disc.invoice_id = p_invoice_id
2133: AND disc.check_id = chk.check_id
2134: AND nvl(chk.future_pay_due_date, chk.check_date) BETWEEN
2135: p_start_date AND p_end_date;