[Home] [Help]
View: OPI_EDW_RSRC_UTIL_V
| Product: | OPI - Operations Intelligence (Obsolete) |
|---|
| Description: | Resource Utilization report source view |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
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
, 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
, 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
, RU.ACT_RES_USAGE ACT_RES_USAGE
, RU.AVAIL_RES AVAIL_RES
FROM OPI_EDW_RES_UTIL_F RU
, EDW_MTL_INVENTORY_LOC_M INV
, EDW_TIME_M TIME
, EDW_BOM_RES_M RES
WHERE INV.INVL_LOCATOR_PK_KEY = RU.LOCATOR_FK_KEY
AND TIME.CDAY_CAL_DAY_PK_KEY = RU.TRX_DATE_FK_KEY
AND RES.RSRC_RESOURCE_PK_KEY = RU.RES_FK_KEY
Columns
| Name |
| ALL_INV_ID |
| PCMP_ID |
| PORG_ID |
| OPERATING_UNIT_ID |
| PLANT_ID |
| ALL_TIME_ID |
| CAL_YR_ID |
| CAL_QTR_ID |
| CAL_PERIOD_ID |
| ALL_RES_ID |
| RES_DEPT_ID |
| RES_GRP_ID |
| RES_RES_ID |
| ACT_RES_USAGE |
| AVAIL_RES |