Determine purchase orders which are still open for a business unit.

SQL Sample Statement Determine purchase orders which are still open for a business unit. SELECT fbu.bu_name procurement_business_unit, poh.segment1 po_number, trunc(poh.creation_date) po_creation_date, pol.line_num line_number, pol.item_description item_description, pol.list_price line_list_price, pv.segment1 supplier_number, pvs.vendor_site_code supplier_site_code FROM po_headers_all poh INNER JOIN po_lines_all pol ON poh.po_header_id = pol.po_header_id AND coalesce(poh.document_status, ‘OPEN’) IN ( ‘OPEN’ ) INNER JOIN poz_suppliers pv ON poh.vendor_id […]