DBA Data[Home] [Help]

APPS.AP_GENERATE_DISTRIBUTIONS_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 217: FROM AP_INVOICE_DISTRIBUTIONS_ALL AID

213: WHERE AIL.INVOICE_ID = P_INVOICE_ID
214: AND AIL.LINE_TYPE_LOOKUP_CODE = 'TAX'
215: AND AIL.amount <>
216: (SELECT nvl(sum(amount),0)
217: FROM AP_INVOICE_DISTRIBUTIONS_ALL AID
218: WHERE AID.INVOICE_ID = AIL.INVOICE_ID
219: AND AID.INVOICE_LINE_NUMBER = AIL.LINE_NUMBER);
220:
221: l_tax_lines VARCHAR2(200);