VIEW: APPS.OPI_EDW_OPI_RES_UTIL_FCV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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