EBS : AP Query : Oracle APPS

Oracle APPS AP Useful Query

Query to get List of Invoice on Hold

SELECT

    aiv.vendor_name,    aiv.vendor_number,       aiv.invoice_num,      aiv.gl_date,       aiv.terms_date,

    aiv.terms_name,      ahv.hold_date,    ahv.release_date 

FROM    apps.ap_invoices_v aiv,apps.ap_holds_v ahv

WHERE

    1=1

    and aiv.invoice_id=ahv.invoice_id

  --  and aiv.invoice_id=apsa.invoice_id

  and   HOLD_LOOKUP_CODE   like 'QTY ORD%' and RELEASE_REASON is null

order by hold_date desc;