1 person found this helpful
If you want to get the operating unit then use this query:
where po_header_id = <header_id>;
If you are looking for the details of the operating unit itself then you may query the tables hr_organization_information and hr_all_organization_units.
How should i link org_id with the tables hr_organization_information and hr_all_organization_units to get operating unit.
ORG_ID must be linked to the ORGANIZATION_ID column in the other two tables.
Moved to the Procurement forum - pl post future questions in appropriate forum
You can find operating units details from PO like below.
select hou.name operating_unit
from po_headers_all pha
Hope this will help you....