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'
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