Foreign Key View for the Sub-Inventory level in the Inventory Location Dimension. The view will return the DataWarehouse Foreign key corresponding to the OLTP subinventory. You can also use the get_stock_room_fk API to do the same.
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT MSI.SECONDARY_INVENTORY_NAME , MSI.ORGANIZATION_ID , MSI.SECONDARY_INVENTORY_NAME||'-'||MP.ORGANIZATION_CODE||'-'||INST.INSTANCE_CODE FROM MTL_SECONDARY_INVENTORIES MSI , HR_ALL_ORGANIZATION_UNITS BG , HR_ALL_ORGANIZATION_UNITS ORG , MTL_PARAMETERS MP , EDW_LOCAL_INSTANCE INST WHERE MSI.ORGANIZATION_ID = MP.ORGANIZATION_ID + 0 AND BG.ORGANIZATION_ID = ORG.BUSINESS_GROUP_ID AND ORG.ORGANIZATION_ID = MP.ORGANIZATION_ID