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 "
0