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_TURNS_PERD_V

Product:	OPI - Operations Intelligence (Obsolete)
Description:	Inventory Turns (Period Level) 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
, /*TIME.ALL_ALL_PK_KEY ALL_TIME_ID
, TIME.CYR_CAL_YEAR_PK_KEY CAL_YR_ID
, TIME.CQTR_CAL_QTR_PK_KEY CAL_QTR_ID
, */ TIME.CPER_CAL_PERIOD_PK_KEY CAL_PERIOD_ID
, ITEM_ORG_FK_KEY ITEM
, -1*IPS.TOT_CUST_SHIP_VAL_G COGS
, IPS.AVG_ONH_VAL_G AVG_ONH_VAL
FROM OPI_EDW_INV_PERD_STAT_F IPS
, EDW_MTL_INVENTORY_LOC_M INV
, EDW_TIME_M TIME
WHERE INV.INVL_LOCATOR_PK_KEY = IPS.LOCATOR_FK_KEY
AND TIME.CDAY_CAL_DAY_PK_KEY = IPS.PRD_DATE_FK_KEY
AND CPER_END_DATE <= SYSDATE

Columns

Name
ALL_LOCATORS_ID
PCMP_ID
PORG_ID
OPERATING_UNIT_ID
PLANT_ID
SUB_INV_ID
CAL_PERIOD_ID
ITEM
COGS
AVG_ONH_VAL