APPS.AP_AUTOSELECT_PKG dependencies on AP_INVOICES_DERIVED_V

Line 2151: FROM ap_invoices_derived_v AIDV

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
2152: WHERE AIDV.invoice_id = inv.invoice_id
2153: AND AIDV.approval_status_lookup_code IN
2154: ('NEVER APPROVED', 'NEEDS REAPPROVAL', 'UNAPPROVED'))
2155: AND EXISTS (SELECT 'Distributions exist'