View: OPI_EDW_OPI_RES_UTIL_FCV

Product:	OPI - Operations Intelligence
Description:	This is the source view for extracting job-resource data from the Discrete Manufacturing source tables.
Implementation/DBA Data:	APPS.OPI_EDW_OPI_RES_UTIL_FCV

View Text

SELECT LOG.RES_UTIL_PK || '-' || INST.INSTANCE_CODE ||'-OPI' RES_UTIL_PK
, LOG.ORGANIZATION_CODE ||'-'||INST.INSTANCE_CODE ||'-PLNT' LOCATOR_FK
, LOG.RESOURCE_CODE ||'-'|| LOG.DEPARTMENT_CODE ||'-'|| LOG.ORGANIZATION_CODE ||'-'|| INST.INSTANCE_CODE RES_FK
, EDW_TIME_PKG.CAL_DAY_FK(LOG.TRX_DATE
, LOG.SOB_ID
, INST.INSTANCE_CODE) TRX_DATE_FK
, LOG.UOM UOM_FK
, INST.INSTANCE_CODE INSTANCE_FK
, 'NA_EDW'
, 'NA_EDW'
, 'NA_EDW'
, 'NA_EDW'
, 'NA_EDW'
, LOG.ACT_RES_USAGE ACT_RES_USAGE
, LOG.AVAIL_RES AVAIL_RES
, LOG.DEPARTMENT_CODE DEPARTMENT
, LOG.TRX_DATE TRX_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL LAST_UPDATE_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM EDW_LOCAL_INSTANCE INST
, OPI_EDW_RES_UTIL_PUSH_LOG LOG

Columns