Product: | PMI - Process Manufacturing Intelligence (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT O.ORGN_CODE || '-' || I.INSTANCE_CODE ||'-'||'OPM' WAREHOUSE_PK
, I.INSTANCE_CODE INSTANCE_CODE
, O.CO_CODE || '-' || I.INSTANCE_CODE ||'-'||'OPM' COMPANY_FK
, O.CO_CODE
, O.ORGN_NAME DESCRIPTION
, O.ORGN_CODE ORGANIZATION_DP
, 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