[Home] [Help]
View: EDW_ORGA_LEG_ENTITY_LCV
| Product: | HRI - Human Resources Intelligence |
| Description: | EDW_ORGA_LEG_ENTITY_LCV is the collection view for HR Legal Entities level of Organization dimension |
| Implementation/DBA Data: |
APPS.EDW_ORGA_LEG_ENTITY_LCV
|
View Text
SELECT LEGAL_ENTITY_PK
, BUSINESS_GROUP_FK
, NAME
, LEGAL_ENTITY_DP
, SET_OF_BOOKS
, DATE_FROM
, DATE_TO
, INT_EXT_FLAG
, ORG_CODE
, ORG_TYPE
, PRIMARY_CST_MTHD
, INSTANCE
, LEGAL_ENTITY_ID
, LEVEL_NAME
, LAST_UPDATE_DATE
, CREATION_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
FROM EDWBV_ORGA_LEG_ENTITY_LCV
Columns
| Name |
| LEGAL_ENTITY_PK |
| BUSINESS_GROUP_FK |
| NAME |
| LEGAL_ENTITY_DP |
| SET_OF_BOOKS |
| DATE_FROM |
| DATE_TO |
| INT_EXT_FLAG |
| ORG_CODE |
| ORG_TYPE |
| PRIMARY_CST_MTHD |
| INSTANCE |
| LEGAL_ENTITY_ID |
| LEVEL_NAME |
| LAST_UPDATE_DATE |
| CREATION_DATE |
| USER_ATTRIBUTE1 |
| USER_ATTRIBUTE2 |
| USER_ATTRIBUTE3 |
| USER_ATTRIBUTE4 |
| USER_ATTRIBUTE5 |