DBA Data[Home] [Help]

APPS.AP_INVOICES_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 3467: FROM AP_INVOICE_DISTRIBUTIONS_ALL D5

3463: AND NOT EXISTS
3464: (SELECT
3465: /*+ NO_UNNEST */
3466: 'distributed line'
3467: FROM AP_INVOICE_DISTRIBUTIONS_ALL D5
3468: WHERE D5.INVOICE_ID = AIL.INVOICE_ID
3469: AND D5.INVOICE_LINE_NUMBER = AIL.LINE_NUMBER
3470: )
3471: UNION ALL

Line 3473: FROM AP_INVOICE_DISTRIBUTIONS_ALL D,

3469: AND D5.INVOICE_LINE_NUMBER = AIL.LINE_NUMBER
3470: )
3471: UNION ALL
3472: SELECT 1
3473: FROM AP_INVOICE_DISTRIBUTIONS_ALL D,
3474: FINANCIALS_SYSTEM_PARAMS_ALL FSP
3475: WHERE D.INVOICE_ID = AI.INVOICE_ID
3476: AND FSP.ORG_ID = AI.ORG_ID
3477: AND FSP.SET_OF_BOOKS_ID = AI.SET_OF_BOOKS_ID