DBA Data[Home] [Help]

APPS.PA_PWP_NOTIFICATION dependencies on AP_HOLDS

Line 498: from ap_holds h

494: ,po_vendors po_vend
495: WHERE linked_inv.invoice_id = ap_inv.invoice_id
496: AND ap_inv.vendor_id = po_vend.vendor_id
497: AND EXISTS (Select 1
498: from ap_holds h
499: where h.invoice_id = ap_inv.invoice_id
500: and release_reason is not null
501: and hold_lookup_code in ('PO Deliverable', 'Pay When Paid')
502: );