[Home] [Help]
| Product: | PMI - Process Manufacturing Intelligence |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT L.WHSE_CODE || '-' || L.LOCATION || '-' || I.INSTANCE_CODE ||'-'||'OPM' LOCATION_PK
, I.INSTANCE_CODE INSTANCE_CODE
, L.WHSE_CODE || '-' || I.INSTANCE_CODE ||'-'||'OPM' WAREHOUSE_FK
, L.LOCATION LOCATION
, L.LOCT_DESC DESCRIPTION
, L.CAPACITY CAPACITY
, L.CAPACITY_UM CAPACITY_UM
, L.WHSE_CODE || '-' || L.LOCATION LOCATION_DP
, L.WHSE_CODE || '-' || L.LOCATION NAME
, L.CREATION_DATE
, L.LAST_UPDATE_DATE
, NULL USER_ATTIBUTE1
, NULL USER_ATRIBUTE1
, NULL USER_ATTRIBUTE3
, NULL USER_ATTRIBUTE4
, NULL USER_ATTRIBUTE5
FROM IC_LOCT_MST L
, EDW_LOCAL_INSTANCE I UNION ALL SELECT W.WHSE_CODE || '-' || 'PWHS' || '-' || I.INSTANCE_CODE ||'-'||'OPM' LOCATION_PK
, I.INSTANCE_CODE INSTANCE_CODE
, W.WHSE_CODE || '-' || I.INSTANCE_CODE ||'-'||'OPM' WAREHOUSE_FK
, TO_CHAR(NULL) LOCATION
, TO_CHAR(NULL) DESCRIPTION
, TO_NUMBER(NULL) CAPACITY
, TO_CHAR(NULL) CAPACITY_UM
, 'ALL LOCATIONS(' || W.WHSE_CODE || ')' LOCATION_DP
, 'ALL LOCATIONS(' || W.WHSE_CODE || ')' NAME
, W.CREATION_DATE
, W.LAST_UPDATE_DATE
, NULL USER_ATTIBUTE1
, NULL USER_ATRIBUTE1
, NULL USER_ATTRIBUTE3
, NULL USER_ATTRIBUTE4
, NULL USER_ATTRIBUTE5
FROM IC_WHSE_MST W
, EDW_LOCAL_INSTANCE I UNION ALL SELECT O.ORGN_CODE || '-' || O.ORGN_CODE || '-' || 'PORG' || '-' || I.INSTANCE_CODE ||'-'||'OPM' LOCATION_PK
, I.INSTANCE_CODE INSTANCE_CODE
, O.ORGN_CODE || '-' || 'PORG' || '-' || I.INSTANCE_CODE ||'-'||'OPM' WAREHOUSE_FK
, TO_CHAR(NULL) LOCATION
, TO_CHAR(NULL) DESCRIPTION
, TO_NUMBER(NULL) CAPACITY
, TO_CHAR(NULL) CAPACITY_UM
, 'ALL LOCATIONS(' || O.ORGN_CODE || ')' LOCATION_DP
, 'ALL LOCATIONS(' || O.ORGN_CODE || ')' NAME
, O.CREATION_DATE
, O.LAST_UPDATE_DATE
, NULL USER_ATTIBUTE1
, NULL USER_ATRIBUTE1
, NULL USER_ATTRIBUTE3
, NULL USER_ATTRIBUTE4
, NULL USER_ATTRIBUTE5
FROM SY_ORGN_MST O
, EDW_LOCAL_INSTANCE I