eTRM uses javascript that opens and focuses a separate window to display reports.
Your browser does not appear to support javascript. This should not prevent you from using
eTRM but it does mean the window focus feature will not work. Please check the contents of
other windows on your desktop if you click on a link that does not appear to do anything.
[Home] [Help]
View: EDW_MTL_LOCATOR_FKV
Product: OPI - Operations Intelligence
Description: 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:
APPS.EDW_MTL_LOCATOR_FKV
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
Columns
Name
INVENTORY_LOCATION_ID
ORGANIZATION_ID
SUBINVENTORY_CODE
LOCATOR_FK