PO approval history table in oracle apps

PO approval history table in oracle apps

In this post , We will be discuss about PO approval history table in oracle apps. This table store all the Approval Action history for the given Purchase orders. We can track all the actions of the approvers for the given purchase order. PO approval history table in oracle apps is quite important in term of Audit purpose to track the Approval related information's.

 

 

 

 

2 Important PO approval history table's

po_action_history

SQL Query to find the PO approval action history information.

SELECT   pah.sequence_num step
       , pah.action_code

       , pah.object_id

       , pah.action_date

       , pah.creation_date

       , pha.segment1 po_num

       , fu.description

       , papf.full_name hr_full_name

       , papf.employee_number emp_no

       , papf.person_id

       , fu.user_name

       , pj.NAME job

    FROM po.po_action_history pah

       , po.po_headers_all pha

       , applsys.fnd_user fu

       , hr.per_all_people_f papf

       , hr.per_all_assignments_f paaf

       , hr.per_jobs pj

   WHERE object_id = pha.po_header_id

     AND pah.employee_id = fu.employee_id

     AND fu.employee_id = papf.person_id

     AND papf.person_id = paaf.person_id

     AND paaf.job_id = pj.job_id

     AND paaf.primary_flag = 'Y'

     AND papf.effective_end_date >=sysdate

     AND paaf.effective_end_date >= sysdate

     AND pah.object_type_code = 'PO'

     AND pah.action_code = 'APPROVE'

  AND papf.full_name =:P_EMPLOYEE_NAME