 |
| Oracle Purchase Requisitions |
SELECT * FROM PO_REQUISITION_HEADERS_ALL WHERE segment1='14493'
Note down requisition_header_id
In our case requisition_header_id is 182811
Pass this requisition_header_id(182811) to po_requisition_lines_all and get REQUISITION_LINE_ID i.e 210039
Pass this information to PO_REQ_DISTRIBUTIONS_ALL and get distribution_id (208518)
select * from po_requisition_lines_all
where requisition_header_id=182811
Requisition Distributions
select * from PO_REQ_DISTRIBUTIONS_ALL --Distribution id 208518
WHERE REQUISITION_LINE_ID=210039
--Pass distribution id as req_distribution_id to po_distributions_all to get po_header_id
select * from po_distributions_all
where req_distribution_id=208518
select * from po_headers_all
where po_header_id=111730 --where segment1 is po number
Hope you understand technical points..
Cheers
For more updates on purchasing visit
