[Home] [Help]
View: EDW_OPI_PRDL_PRDL_LCV
| Product: | OPI - Operations Intelligence (Obsolete) |
|---|
| Description: | Level source view for the Production Line level of the Production Line dimension. |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT WL.LINE_ID || '-' || WL.ORGANIZATION_ID || '-' || INST.INSTANCE_CODE || '-OPI' PRDL_PK
, WL.LINE_CODE PRDL_DP
, 'ALL' ALL_FK
, WL.LINE_CODE NAME
, WL.LINE_CODE PRDL_NAME
, WL.DESCRIPTION DESCRIPTION
, MP.ORGANIZATION_CODE ORGN_CODE
, TO_CHAR(NULL) USER_ATTRIBUTE1
, TO_CHAR(NULL) USER_ATTRIBUTE2
, TO_CHAR(NULL) USER_ATTRIBUTE3
, TO_CHAR(NULL) USER_ATTRIBUTE4
, TO_CHAR(NULL) USER_ATTRIBUTE5
, WL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, WL.CREATION_DATE CREATION_DATE
FROM WIP_LINES WL
, MTL_PARAMETERS MP
, EDW_LOCAL_INSTANCE INST
WHERE WL.ORGANIZATION_ID = MP.ORGANIZATION_ID
Columns
| Name |
| PRDL_PK |
| PRDL_DP |
| ALL_FK |
| NAME |
| PRDL_NAME |
| DESCRIPTION |
| ORGN_CODE |
| USER_ATTRIBUTE1 |
| USER_ATTRIBUTE2 |
| USER_ATTRIBUTE3 |
| USER_ATTRIBUTE4 |
| USER_ATTRIBUTE5 |
| LAST_UPDATE_DATE |
| CREATION_DATE |