DBA Data[Home] [Help]

APPS.JE_JEDEAPVR_XMLP_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 246: AP_INVOICE_DISTRIBUTIONS_ALL D

242: INTO SUM_DISCOUNTS
243: FROM
244: AP_PAYMENT_DISTRIBUTIONS_ALL APD,
245: AP_INVOICE_PAYMENTS AIP,
246: AP_INVOICE_DISTRIBUTIONS_ALL D
247: WHERE APD.INVOICE_PAYMENT_ID = AIP.INVOICE_PAYMENT_ID
248: AND D.INVOICE_LINE_NUMBER = APD.INVOICE_DISTR_LINE_NUMBER
249: AND APD.LINE_TYPE_LOOKUP_CODE = 'DISCOUNT'
250: AND D.LINE_TYPE_LOOKUP_CODE = 'TAX'