3 Replies Latest reply on Feb 22, 2011 2:00 PM by Scott McEwan

    to include po and pr action history

    makdutakdu
      hi
       i have created this query
      as i need report with the followiing columns 
      po#          description           line_num           pr_Action_history(ie action date ,action_code)            po#              po_action_history(po_actioncode,po_action_date)
      
      SELECT PORH.SEGMENT1 pr#,PORH.DESCRIPTION,PORL.LINE_NUM,poha.segment1 po# FROM PO_REQUISITION_HEADERS_ALL PORH,po_requisition_lines_all PORL,PO_REQ_DISTRIBUTIONS_ALL prda 
      ,PO_DISTRIBUTIONS_ALL poda,po_headers_all poha
       WHERE 
       prda.DISTRIBUTION_ID = poda.REQ_DISTRIBUTION_ID
       AND poha.PO_HEADER_ID= poda.PO_HEADER_ID 
       AND prda.REQUISITION_LINE_ID = porl.REQUISITION_LINE_ID 
      AND PORH.requisition_header_id=PORL.requisition_header_id AND PORH.SEGMENT1='4078' 
      is there any way i can include action history for pr as well as po too? i understand that actio_history is taken from po_action_history and depending on the values passed as object_id(column in action_history) we can see either po action history or pr action history
      can someone help me with the above query so that action history of both po and pr can be viewed

      thanking in advance

      Edited by: makdutakdu on May 23, 2010 2:51 PM