DBA Data[Home] [Help]

APPS.JE_IT_LISTING_PKG dependencies on AP_INVOICE_LINES_ALL

Line 793: ap_invoice_lines_all il ,

789: -- Item Line Amount for Credit Memo Invoices
790: DECODE(ih.invoice_type_lookup_code,'CREDIT',DECODE(ih.invoice_currency_code,gv_currency_code, iditem.amount, iditem.base_amount)
791: ,0) cm_amount_item
792: FROM ap_invoices_all ih ,
793: ap_invoice_lines_all il ,
794: ap_invoice_distributions_all id ,
795: ap_invoice_lines_all ilitem ,
796: ap_invoice_distributions_all iditem ,
797: ap_suppliers pv ,

Line 795: ap_invoice_lines_all ilitem ,

791: ,0) cm_amount_item
792: FROM ap_invoices_all ih ,
793: ap_invoice_lines_all il ,
794: ap_invoice_distributions_all id ,
795: ap_invoice_lines_all ilitem ,
796: ap_invoice_distributions_all iditem ,
797: ap_suppliers pv ,
798: ap_supplier_sites_all pvs ,
799: jg_zz_vat_rep_entities repent ,