Oracle Apps Functional All About Oracle Apps functional & Technical FAQs, Tutorials

Sql queries to get organization id from requisition, purchase order and purchase order release?

From Requisition:

select hr.name, prh.segment1, prh.org_id
from po_requisition_headers_all prh,
hr_all_organization_units hr
where prh.org_id = hr.organization_id and
prh.segment1 = '&Enter_Req_Number';

From Purchase Order:

select hr.name, poh.segment1, poh.org_id
from po_headers_all poh,
hr_all_organization_units hr
where poh.org_id = hr.organization_id and
poh.segment1 = '&Enter_PO_Number';

select hr.name, poh.segment1, por.release_num, por.org_id
from po_headers_all poh,
po_releases_all por,
hr_all_organization_units hr
where poh.org_id = hr.organization_id and
por.org_id = poh.org_id and
poh.po_header_id = por.po_header_id and
poh.segment1 = '&Enter_PO_Number' and
por.release_num = '&Enter_Release_Num';

Related Posts

• Adding a Buyer
• Sql queries to validate the data that is part of the approval processing
• How does Requisition Import determine the grouping method for incoming pieces of data?
• What is the Basic Purchasing Setup for Requisition Import?
• Oracle Purchasing Interview Questions