Purchasing

Get Involved. Join the Conversation.

Topic

    Sanjay Shah
    How to query APPROVAL_GROUP_NAME FROM PO_HEADERS_ALL
    Topic posted November 14, 2018 by Sanjay ShahGreen Ribbon: 100+ Points, tagged Approvals, BI Publisher Reports, Requisition Processing 
    124 Views, 2 Comments
    Title:
    How to query APPROVAL_GROUP_NAME FROM PO_HEADERS_ALL
    Summary:
    I am looking to get approval_group_name from po_headers_all for BI report
    Content:

    Hello,

      I can see that APPROVAL_GROUP_NAME EXIST IN POR_AMX_ACTION TABLE, but cannot find query on how to join it to Po_headers_all or por_requisition_headers_all table.

    Thanks for your time and help.

    Regards,

    Sanjay

    Version:
    r13

    Comment

     

    • Ivan Pena

      Hi Sanjay,

      Could you please provide more details about the business requirement you are trying to meet with the report?

      Thanks,

      Ivan

    • Ravi Shankar

      Hi Sanjay,

      PO_HEADERS_ALL and POR_REQUISITION_HEADERS_ALL table contains the information of purchasing and requisitioning documents. POR_AMX* tables contain information of approval rule configuration i.e  POR_AMX_ACTION table contain the information of approval actions configured on approval rules.

      We get the information of APPROVAL_GROUP_NAME from the POR_AMX_ACTION table. But the approval group executed on any purchasing or requisitioning documents depends on the evaluating conditions configured on the approval rule.

      Could you please provide more details about the business requirement, so we can provide the feasibility of requirement from BI report.

      Thanks,

      Ravi