DBA Data[Home] [Help]

APPS.ZX_ZXXINUTR_XMLP_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 262: AP_INVOICE_DISTRIBUTIONS_ALL D

258: SELECT
259: SUM(AMOUNT)
260: INTO L_ITEM_AMOUNT
261: FROM
262: AP_INVOICE_DISTRIBUTIONS_ALL D
263: WHERE D.INVOICE_ID = C_INVOICE_ID
264: AND D.LINE_TYPE_LOOKUP_CODE not in ( 'NONREC_TAX' , 'REC_TAX' , 'TERV' , 'TIPV' , 'AWT' )
265: AND D.TAX_CODE_ID = C_INVOICE_TAX_ID
266: AND ( P_REPORT_BASIS <> 'GL'