[Home] [Help]
View: EDW_ORGA_OPER_UNIT_LCV
Product: | HRI - Human Resources Intelligence |
Description: | EDW_ORGA_OPER_UNIT_LCV is the collection view for Operating Units level of Organization dimension |
Implementation/DBA Data: |
APPS.EDW_ORGA_OPER_UNIT_LCV
|
View Text
SELECT OPERATING_UNIT_PK
, LEGAL_ENTITY_FK
, NAME
, OPERATING_UNIT_DP
, BUSINESS_GROUP
, DATE_FROM
, DATE_TO
, INT_EXT_FLAG
, ORG_TYPE
, ORG_CODE
, PRIMARY_CST_MTHD
, INSTANCE
, OPERATING_UNIT_ID
, LEVEL_NAME
, LAST_UPDATE_DATE
, CREATION_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
FROM EDWBV_ORGA_OPER_UNIT_LCV
Columns
Name |
OPERATING_UNIT_PK |
LEGAL_ENTITY_FK |
NAME |
OPERATING_UNIT_DP |
BUSINESS_GROUP |
DATE_FROM |
DATE_TO |
INT_EXT_FLAG |
ORG_TYPE |
ORG_CODE |
PRIMARY_CST_MTHD |
INSTANCE |
OPERATING_UNIT_ID |
LEVEL_NAME |
LAST_UPDATE_DATE |
CREATION_DATE |
USER_ATTRIBUTE1 |
USER_ATTRIBUTE2 |
USER_ATTRIBUTE3 |
USER_ATTRIBUTE4 |
USER_ATTRIBUTE5 |