Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How can i get the Organization_id (Inventory Organization) ?

604320May 18 2009 — edited May 18 2009
Hi Guys,

I'm making a report in Inventory and we have a Multi organization setup in R12,
In my Report i need to get the Organization_id (Inventory Organization) automatically so i can pass it and use it in the query.

How can i get the Organization_id ? (using a query or a function)

P.S i want Organization_id which is the Inventory Organization
not the Org_id which is the Operating unit
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 15 2009
Added on May 18 2009
17 comments
7,863 views