APPS.AP_AUTOSELECT_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 2142: FROM ap_invoice_distributions_all D2

2138: p_zero_inv_allowed = 'Y')
2139: --Bug 6342390 Added the clause below.
2140: --Commented the fix for the bug6342390, bug6365720
2141: /* AND NOT EXISTS (SELECT 'Invoice is not fully approved'
2142: FROM ap_invoice_distributions_all D2
2143: WHERE D2.invoice_id = inv.invoice_id
2144: AND NVL(D2.match_status_flag, 'N') in ('N', 'S'))*/
2145: --bug6365720
2146: AND NOT EXISTS (SELECT 'Unreleased holds exist'

Line 2438: FROM ap_invoice_distributions_all D2

2434: FROM ap_holds_all H
2435: WHERE H.invoice_id = inv.invoice_id
2436: AND H.release_lookup_code is null)
2437: AND NOT EXISTS (SELECT 'Invoice is not fully approved'
2438: FROM ap_invoice_distributions_all D2
2439: WHERE D2.invoice_id = inv.invoice_id
2440: AND NVL(D2.match_status_flag, 'N') in ('N', 'S'))
2441: AND EXISTS (SELECT 'Distributions exist'
2442: FROM ap_invoice_distributions_all D4

Line 2442: FROM ap_invoice_distributions_all D4

2438: FROM ap_invoice_distributions_all D2
2439: WHERE D2.invoice_id = inv.invoice_id
2440: AND NVL(D2.match_status_flag, 'N') in ('N', 'S'))
2441: AND EXISTS (SELECT 'Distributions exist'
2442: FROM ap_invoice_distributions_all D4
2443: WHERE D4.invoice_id = inv.invoice_id)
2444: -- bug 6456537
2445: AND NOT EXISTS (SELECT 'CCR EXPIRED'
2446: FROM FV_TPP_ASSIGNMENTS_V TPP