DBA Data[Home] [Help]

APPS.AP_RETRO_PRICING_UTIL_PKG dependencies on AP_HOLDS_ALL

Line 135: FROM ap_holds_all H

131: WHERE D.invoice_id = L.invoice_id
132: AND D.invoice_line_number = L.line_number
133: AND nvl(D.match_status_flag, 'X') NOT IN ('A', 'T'))
134: AND EXISTS (SELECT 'Holds other than Price Hold'
135: FROM ap_holds_all H
136: WHERE H.invoice_id = L.invoice_id
137: AND H.release_lookup_code is null
138: AND H.hold_lookup_code <> 'PRICE'));
139: