DBA Data[Home] [Help]

APPS.JL_AR_AP_AWT_REPORTS_PKG dependencies on AP_TAX_CODES

Line 177: AP_TAX_CODES_ALL atc,

173: docs.legal_entity_id legal_entity_id
174: FROM IBY_FD_PAYMENTS_V ipmt,
175: CE_BANK_ACCOUNTS aba,
176: IBY_FD_DOCS_PAYABLE_V docs,
177: AP_TAX_CODES_ALL atc,
178: AP_INVOICE_DISTRIBUTIONS_ALL aid,
179: AP_INVOICE_PAYMENTS_ALL aip,
180: PO_VENDORS pv
181: WHERE ipmt.payment_instruction_id = p_payment_instruction_id

Line 214: ap_tax_codes_all atc,

210: docs.legal_entity_id legal_entity_id
211: FROM iby_fd_payments_v ipmt,
212: ce_bank_accounts aba,
213: iby_fd_docs_payable_v docs,
214: ap_tax_codes_all atc,
215: AP_AWT_TEMP_DISTRIBUTIONS_ALL aid,
216: ap_selected_invoices_all api,
217: po_vendors pv
218: WHERE ipmt.payment_instruction_id = p_payment_instruction_id

Line 519: ap_tax_codes atc

515:
516: SELECT (jlts.calc_wh_amnt - jlts.act_wheld_amnt)
517: INTO v_amount
518: FROM jl_ar_ap_sup_awt_cr_lts jlts,
519: ap_tax_codes atc
520: WHERE
521: jlts.po_vendor_id = v_vendor_id
522: and jlts.awt_type_code = v_awt_type_code
523: and jlts.tax_id = atc.tax_id