DBA Data[Home] [Help]

APPS.ZX_JL_EXTRACT_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 8922: FROM ap_invoice_distributions aid

8918: ELSIF P_REPORT_NAME = 'JLARPPFF' THEN
8919:
8920: SELECT nvl(SUM(NVL(aid.base_amount, aid.amount)),0)
8921: INTO l_total_doc_amt_tbl(p_trx_id_tbl(i))
8922: FROM ap_invoice_distributions aid
8923: WHERE aid.invoice_id = p_trx_id_tbl(i)
8924: AND aid.line_type_lookup_code <> 'AWT';
8925: END IF;
8926: