Foreign Key View for the Locator level in the Inventory Location Dimension. The view will return the DataWarehouse Foreign key corresponding to the OLTP locator. You can also use the get_locator_fk API to do the same.
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT LOCF.INVENTORY_LOCATION_ID , LOCF.ORGANIZATION_ID , LOCF. SUBINVENTORY_CODE , LOCF.SUBINVENTORY_CODE||'-'||MP.ORGANIZATION_CODE||'-'||INST.INSTANCE_CODE FROM MTL_ITEM_LOCATIONS_KFV LOCF , MTL_PARAMETERS MP , EDW_LOCAL_INSTANCE INST WHERE LOCF.ORGANIZATION_ID = MP.ORGANIZATION_ID AND (LOCF.PHYSICAL_LOCATION_ID = LOCF.INVENTORY_LOCATION_ID OR LOCF.PHYSICAL_LOCATION_ID IS NULL) UNION ALL SELECT -1 , SUB.ORGANIZATION_ID , SUB.SECONDARY_INVENTORY_NAME , 'NULL_LOCATOR'||'-'||SUB.SECONDARY_INVENTORY_NAME||'-'||MP.ORGANIZATION_CODE||'-'||INST.INSTANCE_CODE FROM MTL_SECONDARY_INVENTORIES SUB , MTL_PARAMETERS MP , EDW_LOCAL_INSTANCE INST WHERE SUB.ORGANIZATION_ID = MP.ORGANIZATION_ID
[Home] [Help]