[Home] [Help]
View: EDW_MTL_ILDM_OU_LCV
| Product: | OPI - Operations Intelligence (Obsolete) |
|---|
| Description: | Source View for the Operating Unit level of the Inventory Locator Dimension |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT OPERATING_UNIT_PK
, OPERATING_UNIT_DP
, NAME
, BUSINESS_GROUP
, DATE_FROM
, DATE_TO
, INT_EXT_FLAG
, ORG_TYPE
, ORG_CODE
, PRIMARY_CST_MTHD
, INSTANCE
, 'ALL'
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, LAST_UPDATE_DATE
, LAST_UPDATE_DATE
FROM EDW_ORGA_OPER_UNIT_LCV
Columns
| Name |
| OPERATING_UNIT_PK |
| OPERATING_UNIT_DP |
| NAME |
| BUSINESS_GROUP |
| DATE_FROM |
| DATE_TO |
| INT_EXT_FLAG |
| ORG_TYPE |
| ORG_CODE |
| PRIMARY_CST_MTHD |
| INSTANCE |
| ALL_FK |
| USER_ATTRIBUTE1 |
| USER_ATTRIBUTE2 |
| USER_ATTRIBUTE3 |
| USER_ATTRIBUTE4 |
| USER_ATTRIBUTE5 |
| CREATION_DATE |
| LAST_UPDATE_DATE |