Wednesday, December 16, 2015

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;

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect