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_YR_V

Product:	OPI - Operations Intelligence (Obsolete)
Description:	Inventory Turns (Year 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.CYR_CAL_YEAR_PK_KEY CAL_YR_ID
, ITEM_ORG_FK_KEY ITEM
, IT.ALL_ALL_PK_KEY ALL_ITEMS_ID
, -1*SUM(IPS.TOT_CUST_SHIP_VAL_G) COGS
, AVG(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
, EDW_ITEMS_M IT
WHERE INV.INVL_LOCATOR_PK_KEY = IPS.LOCATOR_FK_KEY
AND IT.IREV_ITEM_REVISION_PK_KEY = IPS.ITEM_ORG_FK_KEY
AND TIME.CDAY_CAL_DAY_PK_KEY = IPS.PRD_DATE_FK_KEY
AND CPER_END_DATE <= SYSDATE GROUP BY INV.ALL_PK_KEY
, INV.PCMP_OPM_COMPANY_PK_KEY
, INV.PORG_OPM_ORGANIZATION_PK_KEY
, INV.OU_OPERATING_UNIT_PK_KEY
, INV.PLNT_PLANT_PK_KEY
, INV.SUBI_STOCK_ROOM_PK_KEY
, TIME.CYR_CAL_YEAR_PK_KEY
, ITEM_ORG_FK_KEY
, LOT_FK_KEY
, IT.ALL_ALL_PK_KEY

Columns

Name
ALL_LOCATORS_ID
PCMP_ID
PORG_ID
OPERATING_UNIT_ID
PLANT_ID
SUB_INV_ID
CAL_YR_ID
ITEM
ALL_ITEMS_ID
COGS
AVG_ONH_VAL