Reporting and Analytics for SCM

Get Involved. Join the Conversation.

Topic

    Farooq Haider Syed, PMP
    Analysis & Query - for PRs history or apprvoal level
    Topic posted December 20, 2017 by Farooq Haider Syed, PMPBlack Diamond: 60,000+ Points, tagged BI Publisher, OBIEE Answers, OTBI, Procurement 
    152 Views, 3 Comments
    Title:
    Analysis & Query - for PRs history or apprvoal level
    Summary:
    Need to develop analysis to see the approval status and history of certiain PR
    Content:

    Hi,

     

    I am trying to get the catalog or query to develop the analysis and report for approval status of any PR.

    any one can plz help.

     

    Thanks

    Farooq

    Comment

     

    • Farooq Haider Syed, PMP

      Query find as attached.

    • Farooq Haider Syed, PMP

      Find REQ Header_ID

      select * from POR_REQUISITION_HEADERS_ALL where requisition_number = 'Req_Num';

      Then use this query...
      SELECT pah.*, ppnf.full_name
        FROM po_action_history pah, per_person_names_f ppnf
       WHERE     pah.OBJECT_TYPE_CODE = 'REQ'
             AND pah.object_id = :P_REQ_HDR_ID
             AND pah.performer_id = ppnf.person_id
             AND ppnf.NAME_TYPE = 'GLOBAL'

      • Koteswararao Yenikepalli

        but in this given query it will not give the history of the approval if the PR is reassigned to the another person 

         

        if you have any query to get the approval history if the requisition has been reassigned to the another approval for this case we have raised the sr and we are using the SasS oracle provided the some of the tables but those tables we couldn't able to read the data due to the insufficient privileges 

         

         

        if you have any query regarding this could you please share it.

         

        Thank you for your support