VIEW: APPS.OPI_EDW_INV_TURNS_QTR_V

Source

View Text - Preformatted

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.cqtr_cal_qtr_pk_key CAL_QTR_ID, ITEM_ORG_FK_KEY item, -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 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 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.cqtr_cal_qtr_pk_key, ITEM_ORG_FK_KEY, LOT_FK_KEY

View Text - HTML Formatted

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.CQTR_CAL_QTR_PK_KEY CAL_QTR_ID
, ITEM_ORG_FK_KEY ITEM
, -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
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 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.CQTR_CAL_QTR_PK_KEY
, ITEM_ORG_FK_KEY
, LOT_FK_KEY