1 Reply Latest reply on Jun 24, 2020 12:32 PM by Bommi

    Requisition Approval Group Members(Approvers) Backend Table

    4238537

      Hello,

       

      Could you please suggest the backend table which stores the requisition approval group(BPM Worklist)  members/Approvers details.

      As per our initial background work, we found

      POR_AMX_RULES -- Approval rules information is available here

      POR_AMX_ACTIONS -- We found the Approval Group Name information

       

      We would like to know the list of approvers of that Group.

       

      Kindly suggest.

       

      Thanks

      Manoj R

        • 1. Re: Requisition Approval Group Members(Approvers) Backend Table
          Bommi

          Hi,

           

          Are you using R12 or Cloud? If R12, check if below query helps you

           

          select AME_A.FND_APPLICATION_ID, AME_A.APPLICATION_NAME,AME_A.TRANSACTION_TYPE_ID,AME_A.APPLICATION_ID AME_APPLICATION_ID

                 ,R_U.RULE_ID,R_U.CREATION_DATE,R_U.START_DATE,R_U.END_DATE,R_BY.USER_NAME RULE_CREATED_BY

                 ,RU.DESCRIPTION

                 ,ICT.USER_ITEM_CLASS_NAME ITEM_CLASS

                 ,C_U.CONDITION_ID

                 ,CO.ATTRIBUTE_ID,CO.PARAMETER_THREE CURRENCY,CO.PARAMETER_ONE,CO.PARAMETER_TWO,CO.INCLUDE_LOWER_LIMIT,CO.INCLUDE_UPPER_LIMIT

                 ,ATTR.name CONDITION_NAME,ATTR.DESCRIPTION ATTRIBUTE_DESCRIPTION

                 ,A_U.ACTION_ID

                 ,ACT.ACTION_TYPE_ID,ACT.DESCRIPTION action

                 ,a_t_tl.user_action_type_name action_type

          from AME_CALLING_APPS AME_A

               ,AME_RULE_USAGES R_U

               ,FND_USER R_BY

               ,AME_RULES RU

               ,AME_ITEM_CLASSES_TL ICT

               ,AME_CONDITION_USAGES C_U

               ,AME_CONDITIONS CO

               ,AME_ATTRIBUTES ATTR

               ,AME_ACTION_USAGES A_U

               ,AME_ACTIONS ACT

               ,AME_ACTION_TYPES_TL a_t_tl

          where 1=1

          and APPLICATION_NAME='Purchase Requisition Approval'

          and AME_A.APPLICATION_ID=R_U.ITEM_ID

          and sysdate between AME_A.START_DATE and AME_A.END_DATE

          and sysdate between R_U.START_DATE and R_U.END_DATE

          and R_U.CREATED_BY=R_BY.USER_ID

          and R_U.RULE_ID=RU.RULE_ID

          and sysdate between RU.START_DATE and RU.END_DATE

          and RU.ITEM_CLASS_ID=ICT.ITEM_CLASS_ID

          and R_U.RULE_ID=C_U.RULE_ID

          and sysdate between C_U.START_DATE and C_U.END_DATE

          and C_U.CONDITION_ID=CO.CONDITION_ID

          and sysdate between CO.START_DATE and CO.END_DATE

          and CO.ATTRIBUTE_ID=ATTR.ATTRIBUTE_ID

          and sysdate between ATTR.START_DATE and ATTR.END_DATE

          and R_U.RULE_ID=A_U.RULE_ID

          and sysdate between A_U.START_DATE and A_U.END_DATE

          and A_U.ACTION_ID=ACT.ACTION_ID

          and sysdate between ACT.START_DATE and ACT.END_DATE

          and act.action_type_id=a_t_tl.action_type_id;

           

           

          Mark my answer as helpful or correct if anyways helped you.

           

           

          Regards,

          Bommi