DBA Data[Home] [Help]

APPS.ZX_JL_EXTRACT_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 8446: FROM ap_invoice_distributions aid

8442: ELSIF P_REPORT_NAME = 'JLARPPFF' THEN
8443:
8444: SELECT abs(nvl(SUM(NVL(aid.base_amount, aid.amount)),0))
8445: INTO l_total_doc_amt_tbl(p_trx_id_tbl(i))
8446: FROM ap_invoice_distributions aid
8447: WHERE aid.invoice_id = p_trx_id_tbl(i)
8448: AND aid.line_type_lookup_code <> 'AWT';
8449: END IF;
8450: