[Home] [Help]
View: EDW_OPI_OPRN_OPRC_LCV
| Product: | OPI - Operations Intelligence (Obsolete) |
|---|
| Description: | This View Sources the Operations Class associated to operations from Discrete and Process Manufacturing |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT 'ALL'
, OPRN_CLASS||'-'||I.INSTANCE_CODE||'-OPM'
, 'OPRC'
, OPRN_CLASS_DESC||'('||OPRN_CLASS||')'
, OPRN_CLASS_DESC
, NULL
, NULL
, NULL
, NULL
, NULL
, FO.LAST_UPDATE_DATE
, FO.CREATION_DATE
FROM FM_OPRN_CLS FO
, EDW_LOCAL_INSTANCE I
Columns
| Name |
| ALL_FK |
| OPRC_PK |
| OPRC_DP |
| NAME |
| DESCRIPTION |
| USER_ATTRIBUTE1 |
| USER_ATTRIBUTE2 |
| USER_ATTRIBUTE3 |
| USER_ATTRIBUTE4 |
| USER_ATTRIBUTE5 |
| LAST_UPDATE_DATE |
| CREATION_DATE |