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_SUB_INV_FKV
Product: OPI - Operations Intelligence
Description: 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:
APPS.EDW_MTL_SUB_INV_FKV
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
Columns
Name
SECONDARY_INVENTORY_NAME
ORGANIZATION_ID
STOCK_ROOM_FK