DBA Data[Home] [Help]

APPS.AP_AUTOSELECT_PKG dependencies on AP_HOLDS

Line 2147: FROM ap_holds H

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'
2147: FROM ap_holds H
2148: WHERE H.invoice_id = inv.invoice_id
2149: AND H.release_lookup_code is null)
2150: AND NOT EXISTS (SELECT 'Invoice is not fully approved'
2151: FROM ap_invoices_derived_v AIDV

Line 2434: FROM ap_holds_all H

2430: or p_pay_group_option = 'ALL')
2431: AND ((p_zero_inv_allowed = 'N' AND ps.amount_remaining <> 0) OR
2432: p_zero_inv_allowed = 'Y')
2433: AND NOT EXISTS (SELECT 'Unreleased holds exist'
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