PO: Query to fetch all Contracts and Blanket POs and its details

1. Query to get list of Blanket and Contract POs

SELECT hou.name              ou,

       pha.segment1          cpa_po_number,

       pha.creation_date,

       pv.vendor_name        supplier,

       pvsa.vendor_site_code site,

       pvsa.attribute4,

       pvsa.attribute5,

       pvsa.attribute6,

       pvsa.attribute7

  FROM po.po_headers_all          pha,

       apps.ap_suppliers          pv,

       apps.ap_supplier_sites_all pvsa,

       apps.hr_operating_units    hou

 WHERE pha.vendor_id = pv.vendor_id

   AND pha.vendor_site_id = pvsa.vendor_site_id

   AND pha.org_id = pvsa.org_id

   AND pha.org_id = hou.organization_id

   AND pha.type_lookup_code IN ( 'CONTRACT','BLANKET')

   AND pha.authorization_status = 'APPROVED'

 ORDER BY 3;