Friday, January 8, 2016

Purchase Order from Requisition Number



This is the query to find out the purchase order number from requisition number

select  distinct pha.segment1 from po_headers_all pha,po_distributions_all pda,po_req_distributions_all rda,
po_requisition_headers_all rha,po_requisition_lines_all rla where
pha.po_header_id=pda.po_header_id and
pda.req_distribution_id=rda.distribution_id and
rda.requisition_line_id=rla.requisition_line_id and
rla.requisition_header_id=rha.requisition_header_id and
rha.segment1='&Requisition'

You can also find out the requisition number from purchase order number by using query given below

select distinct rha.segment1 from po_requisition_headers_all rha,po_requisition_lines_all rla,
po_req_distributions_all rda,po_distributions_all pda,po_headers_all pha where
rha.requisition_header_id=rla.requisition_header_id and
rla.requisition_line_id=rda.requisition_line_id and
rda.distribution_id=pda.req_distribution_id and
pda.po_header_id=pha.po_header_id and
pha.segment1='&PO_Number'

1 comment:

Jessica Meri said...

this article nice ,this information is very useful to me and our company ithubonlinetraining