Total Pageviews

January 25, 2016

1/25/2016 03:40:00 AM
Oracle Purchase Requisitions
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




Oracle APPS Purchasing


Hope you understand technical points..

Cheers
For more updates on purchasing visit





 
Related Posts Plugin for WordPress, Blogger...