Wednesday, 8 May 2019

How to know the position hierarchy used in a PO document - Oracle EBS R12

https://purchasingpo.blogspot.com/2019/05/how-to-know-position-hierarchy-used-in.html

Requisitions

select prh.segment1, pps.name
from po_requisition_headers_all prh, po_action_history pah, per_position_structures pps
where pah.approval_path_id = pps.position_structure_id
and prh.requisition_header_id = pah.object_id
and object_type_code = 'REQUISITION'
and action_code = 'SUBMIT'
and prh.segment1 = '&REQNUMBER'

Purchase Orders

select ph.segment1, pps.name
from po_headers_all ph, po_action_history pah, per_position_structures pps
where pah.approval_path_id = pps.position_structure_id
and ph.po_header_id = pah.object_id
and object_type_code = 'PO'
and action_code = 'SUBMIT'
and ph.segment1 = '&PONUMBER'

No comments:

Post a Comment