You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

SQL query to get Inventory Org of a BU in Configure Procurement Business Function UI

Hi experts,

We need to get the Inventory Organization of a Business Unit that shown on "Configure Procurement Business Function" User Interface.

We tried using this query,

SELECT  

FABU.BU_NAME,

IOP.ORGANIZATION_CODE,

HOU.NAME  ORGANIZATION_NAME

FROM

FUN_ALL_BUSINESS_UNITS_V            FABU, 

INV_ORG_PARAMETERS                  IOP,

HR_ORGANIZATION_UNITS_F_TL          HOU

WHERE    1 = 1

AND FABU.BU_NAME = :P_BU_NAME

AND FABU.BU_ID = IOP.BUSINESS_UNIT_ID

AND IOP.ORGANIZATION_ID = HOU.ORGANIZATION_ID

But this query gives all Inventory Organizations related to a Business Unit shown under the "Manage Inventory Organizations" User Interface.

We only need the Inventory Organization value shown on "

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!