Query To Find the Drop Ship Purchase Orders

SELECT

  prh.segment1 req_num,

  prh.INTERFACE_SOURCE_CODE,

  prl.line_num req_line_num,

  poll.line_location_id po_line_loc_id,

  poh.segment1 po_blanket_num,

  poh.org_id org,

  hr.name,

  oed.line_location_id oe_line_loc

FROM

  po_requisition_headers_all prh,

  po_requisition_lines_all prl,

  po_line_locations_all poll,

  po_headers_all poh,

  oe_drop_ship_sources oed,

  hr_all_organization_units hr

WHERE 1=1

  AND prh.requisition_header_id = prl.REQUISITION_HEADER_ID

  AND hr.organization_id = poh.org_id

  AND prl.line_location_id = poll.line_location_id

  AND poh.po_header_id = poll.po_header_id

  AND oed.line_location_id = poll.line_location_id

  AND poh.org_id = 204

ORDER BY poh.creation_date DESC;