Vendor Po Shipment Details Report

Source Code:

SELECT PV.segment1 "Vendor Number",
         PV.vendor_name "Vendor Name",
         PVSA.address_line1 "Vendor Address",
         PVSA.city "City",
         PHA.segment1 "PO Number",
         PHA.type_lookup_code "PO Type",
         PHA.creation_date "Creation Date",
         PHA.currency_code "Currency",
         HL1.location_code "Bill To Location",
         HL2.location_code "Ship To Location",
         HE.full_name "Buyer Name"
    FROM po_vendors PV,
         po_vendor_sites_all PVSA,
         po_headers_all PHA,
         po_line_locations_all PLA,
         hr_locations HL1,
         hr_locations HL2,
         hr_employees HE
   WHERE     PV.vendor_id = PVSA.vendor_id
         AND PHA.po_header_id = PLA.po_header_id
         AND PLA.ship_to_location_id = HL1.ship_to_location_id
         AND PLA.ship_to_location_id = HL2.ship_to_location_id
         AND PHA.bill_to_location_id = HL1.location_id
         AND PHA.ship_to_location_id = HL2.location_id
         AND PV.bill_to_location_id = HL1.location_id
         AND PV.bill_to_location_id = HL2.location_id
         AND HE.employee_id = PHA.agent_id
         AND PV.segment1 BETWEEN NVL (:P_PO_NUM_FROM, PV.segment1)
         AND NVL (:P_PO_NUM_TO, PV.segment1)
GROUP BY PV.segment1,
         PV.vendor_name,
         PVSA.address_line1,
         PVSA.city,
         PHA.segment1,
         PHA.type_lookup_code,
         PHA.creation_date,
         PHA.currency_code,
         HL1.location_code,
         HL2.location_code,
         HE.full_name