[Home] [Help]
View: EDW_PMI_PMIL_PWHS_LCV
| Product: | PMI - Process Manufacturing Intelligence (Obsolete) |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT W.WHSE_CODE || '-' || I.INSTANCE_CODE ||'-'||'OPM' WAREHOUSE_PK
, I.INSTANCE_CODE INSTANCE_CODE
, W.ORGN_CODE || '-' || I.INSTANCE_CODE ||'-'||'OPM' ORGANIZATION_FK
, W.WHSE_CODE
, W.WHSE_NAME DESCRIPTION
, W.WHSE_CODE WAREHOUSE_DP
, W.WHSE_CODE NAME
, W.CREATION_DATE CREATION_DATE
, W.LAST_UPDATE_DATE LAST_UPDATE_DATE
, NULL USER_ATTRIBUTE1
, NULL USER_ATTRIBUTE2
, NULL USER_ATTRIBUTE3
, NULL USER_ATTRIBUTE4
, NULL USER_ATTRIBUTE5
FROM IC_WHSE_MST W
, EDW_LOCAL_INSTANCE I UNION ALL SELECT O.ORGN_CODE || '-' || 'PORG' || '-' || I.INSTANCE_CODE ||'-'||'OPM' WAREHOUSE_PK
, I.INSTANCE_CODE INSTANCE_CODE
, O.ORGN_CODE || '-' || I.INSTANCE_CODE ||'-'||'OPM' ORGANIZATION_FK
, NULL WAREHOUSE
, NULL DESCRIPTION
, 'ALL WAREHOUSES(' || O.ORGN_CODE || ')' WAREHOUSE_DP
, 'ALL WAREHOUSES(' || O.ORGN_CODE || ')' NAME
, O.CREATION_DATE CREATION_DATE
, O.LAST_UPDATE_DATE LAST_UPDATE_DATE
, NULL USER_ATTRIBUTE1
, NULL USER_ATTRIBUTE2
, NULL USER_ATTRIBUTE3
, NULL USER_ATTRIBUTE4
, NULL USER_ATTRIBUTE5
FROM SY_ORGN_MST O
, EDW_LOCAL_INSTANCE I
Columns
| Name |
| WAREHOUSE_PK |
| INSTANCE_CODE |
| ORGANIZATION_FK |
| WAREHOUSE |
| DESCRIPTION |
| WAREHOUSE_DP |
| NAME |
| CREATION_DATE |
| LAST_UPDATE_DATE |
| USER_ATTRIBUTE1 |
| USER_ATTRIBUTE2 |
| USER_ATTRIBUTE3 |
| USER_ATTRIBUTE4 |
| USER_ATTRIBUTE5 |