Work Orders linked to Requisitions

  SELECT DISTINCT

         prha.segment1 req

       , we.wip_entity_name wo

       , prha.creation_date req_date

       , fu.description

       , prha.description

       , prha.authorization_status status

       , PRLA.SUGGESTED_VENDOR_NAME supplier

    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 > '25-JUL-2013'

ORDER BY prha.creation_date DESC;