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: OPI_EDW_INV_QTY_PERD_V

Product:	OPI - Operations Intelligence (Obsolete)
Description:	On Hand Inventory Quantity report source view
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT INV.ALL_PK_KEY ALL_LOCATORS_ID
, INV.PCMP_OPM_COMPANY_PK_KEY PCMP_ID
, INV.PORG_OPM_ORGANIZATION_PK_KEY PORG_ID
, INV.OU_OPERATING_UNIT_PK_KEY OPERATING_UNIT_ID
, INV.PLNT_PLANT_PK_KEY PLANT_ID
, INV.SUBI_STOCK_ROOM_PK_KEY SUB_INV_ID
, INV.INVL_LOCATOR_PK_KEY LOCATOR_ID
, TIME.CPER_CAL_PERIOD_PK_KEY CAL_PERIOD_ID
, IT.ALL_ALL_PK_KEY ALL_ITEMS_ID
, IT.CO16_CATEGORY_PK_KEY ITEM_CAT_ID
, IT.IREV_ITEM_REVISION_PK_KEY ITEM_ID
, UOM.UOM_EDW_UOM_PK_KEY UOM_ID
, NVL(IPS.END_ONH_QTY
, 0) EONH_INV_QTY
FROM OPI_EDW_INV_PERD_STAT_F IPS
, EDW_MTL_INVENTORY_LOC_M INV
, EDW_ITEMS_M IT
, EDW_TIME_M TIME
, EDW_MTL_UOM_M UOM
WHERE INV.INVL_LOCATOR_PK_KEY = IPS.LOCATOR_FK_KEY
AND TIME.CDAY_CAL_DAY_PK_KEY = IPS.PRD_DATE_FK_KEY
AND IT.IREV_ITEM_REVISION_PK_KEY = IPS.ITEM_ORG_FK_KEY
AND UOM.UOM_EDW_UOM_PK_KEY = IPS.BASE_UOM_FK_KEY

Columns

Name
ALL_LOCATORS_ID
PCMP_ID
PORG_ID
OPERATING_UNIT_ID
PLANT_ID
SUB_INV_ID
LOCATOR_ID
CAL_PERIOD_ID
ALL_ITEMS_ID
ITEM_CAT_ID
ITEM_ID
UOM_ID
EONH_INV_QTY