4 Replies Latest reply on Mar 16, 2016 11:19 AM by Jagadekara

    Approval Position on Purchase Requisition Form

    User415575


      Hi,

       

      In Purchase Requisition Form (Oracle EBS), how we get the Position of a person who Approved the PR. In View Action History, Approval name is appearing but not the Position.

       

      Please advice.

       

      We want to trace that how many PR's approved by specific Position like "General Manager HR"

       

      Regards,

      Mohsin

        • 1. Re: Approval Position on Purchase Requisition Form
          Jagadekara

          Hi,

           

          Write a query to check from back end.

          • 2. Re: Approval Position on Purchase Requisition Form
            User415575

            Is there any work flow table where the Position of Approval is save.

            • 3. Re: Approval Position on Purchase Requisition Form
              anasazii

              check po.po_action_history to get approver information and use that to derive the employee information

              • 4. Re: Approval Position on Purchase Requisition Form
                Jagadekara

                Hi,

                 

                Check the following query, it may give you an idea.

                 

                select *

                from(select 'PO' transaction_type

                      ,pha.segment1 invoice_num

                      ,asp.vendor_name

                      ,(select sum(nvl(pla.unit_price,0)*nvl(pla.quantity,0)) from po_lines_all pla where pla.po_header_id=pha.po_header_id) invoice_amount

                      ,decode(pha.org_id,81,'OU1',82,'OU2') source

                      ,he.full_name approver_name

                      ,pah.action_code action

                      ,to_char(pah.creation_date,'DD-MON-YYYY HH24:MI:SS') inbox_date

                      ,to_char(pah.action_date,'DD-MON-YYYY HH24:MI:SS') action_date

                      ,round(((to_date(to_char(pah.action_date,'DD-MON-YYYY HH24:MI:SS'),'dd-mon-yyyy hh24:mi:ss')-to_date(to_char(pah.creation_date,'DD-MON-YYYY HH24:MI:SS'),'dd-mon-yyyy hh24:mi:ss'))*24),2) time_taken

                      --,pah.sequence_num

                from po_action_history pah

                     ,po_headers_all pha

                     ,ap_suppliers asp

                     ,hr_employees he

                where 1=1

                --and pah.object_id=23003

                  and pha.po_header_id=pah.object_id

                  and asp.vendor_id=pha.vendor_id

                  and pah.employee_id=he.employee_id

                  and pha.org_id=nvl(:P_ORG_ID,pha.org_id)

                  and pah.creation_date between :P_FROM_DATE and :P_TO_DATE

                  --and he.full_name=nvl(:P_APPROVER,he.full_name)

                  and he.employee_id=nvl(:P_APPROVER,he.employee_id)

                  and 'PO'=nvl(:P_TRX_TYPE,'PO')

                order by pah.object_id,pah.sequence_num)

                b

                where 1=1