1 Reply Latest reply on Feb 25, 2009 7:56 AM by 468695

    Requistion Query

    680542
      I want the List of Requisition and Purchase Order which we have auto created .
      Can any one send me the Query to do so
        • 1. Re: Requistion Query
          468695
          Dear,

          Here is a query to find po against requisition.

          select poh.segment1 po_number
          ,pol.line_num po_line_number
          ,rh.segment1 req_number
          ,rl.line_num req_line_number
          from po_headers_all poh
          ,po_lines_all pol
          ,po_line_locations_all poll
          ,po_requisition_headers_all rh
          ,po_requisition_lines_all rl
          where rh.requisition_header_id = rl.requisition_header_id
          and rl.line_location_id = poll.line_location_id
          and poh.po_header_id = pol.po_header_id
          and pol.po_line_id = poll.po_line_id


          Regards,

          Jamil