DBA Data[Home] [Help]

APPS.AP_INVOICES_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 1614: FROM ap_invoice_distributions aid

1610:
1611: -- Bug 10103631
1612: SELECT CASE WHEN NULLIF(X_Invoice_Num,ai.invoice_num) IS NOT NULL
1613: AND EXISTS ( SELECT 1
1614: FROM ap_invoice_distributions aid
1615: WHERE aid.invoice_id = ai.invoice_id
1616: AND aid.accounting_event_id IS NOT NULL
1617: AND rownum = 1
1618: )

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