VIEW: APPS.OPI_EDW_RSRC_EFFICIENCY_V

Source

View Text - Preformatted

SELECT inv.ALL_PK_KEY ALL_INV_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, uom.UOM_EDW_UOM_PK_KEY UOM_ID, uom.UOM_NAME UOM_NAME, res.ALL_ALL_PK_KEY All_RES_ID, res.DEPT_DEPARTMENT_PK_KEY RES_DEPT_ID, res.RGRP_RESOURCE_GROUP_PK_KEY RES_GRP_ID, res.RSRC_RESOURCE_PK_KEY RES_RES_ID, jr.ACT_RSRC_USAGE ACT_USAGE, jr.PLN_RSRC_USAGE PLN_RSRC_USAGE, jr.STND_RSRC_USAGE STD_USAGE from OPI_EDW_JOB_RSRC_F jr, EDW_MTL_INVENTORY_LOC_M inv, EDW_TIME_M time, EDW_BOM_RES_M res, EDW_MTL_UOM_M uom WHERE inv.INVL_LOCATOR_PK_KEY = jr.LOCATOR_FK_KEY AND time.CDAY_CAL_DAY_PK_KEY = jr.TRX_DATE_FK_KEY AND res.RSRC_RESOURCE_PK_KEY = jr.RSRC_FK_KEY AND jr.QTY_UOM_FK_KEY = uom.UOM_EDW_UOM_PK_KEY

View Text - HTML Formatted

SELECT INV.ALL_PK_KEY ALL_INV_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
, UOM.UOM_EDW_UOM_PK_KEY UOM_ID
, UOM.UOM_NAME UOM_NAME
, RES.ALL_ALL_PK_KEY ALL_RES_ID
, RES.DEPT_DEPARTMENT_PK_KEY RES_DEPT_ID
, RES.RGRP_RESOURCE_GROUP_PK_KEY RES_GRP_ID
, RES.RSRC_RESOURCE_PK_KEY RES_RES_ID
, JR.ACT_RSRC_USAGE ACT_USAGE
, JR.PLN_RSRC_USAGE PLN_RSRC_USAGE
, JR.STND_RSRC_USAGE STD_USAGE
FROM OPI_EDW_JOB_RSRC_F JR
, EDW_MTL_INVENTORY_LOC_M INV
, EDW_TIME_M TIME
, EDW_BOM_RES_M RES
, EDW_MTL_UOM_M UOM
WHERE INV.INVL_LOCATOR_PK_KEY = JR.LOCATOR_FK_KEY
AND TIME.CDAY_CAL_DAY_PK_KEY = JR.TRX_DATE_FK_KEY
AND RES.RSRC_RESOURCE_PK_KEY = JR.RSRC_FK_KEY
AND JR.QTY_UOM_FK_KEY = UOM.UOM_EDW_UOM_PK_KEY