Work Orders linked to Requisitions and POs

SELECT DISTINCT

       prha.segment1

     , we.wip_entity_name wo

     , prha.creation_date

     , fu.description

     , prha.description

  FROM po.po_requisition_headers_all prha

     , po.po_requisition_lines_all prla

     , applsys.fnd_user fu

     , wip.wip_entities we

 WHERE prha.requisition_header_id = prla.requisition_header_id

   AND prha.created_by = fu.user_id

   AND prla.wip_entity_id = we.wip_entity_id

   AND prha.creation_date > '16-JUL-2013';