View: EDW_ORGA_ORG_LCV

Product:	HRI - Human Resources Intelligence
Description:	EDW_ORGA_ORG_LCV is the collection view for Organization level of Organization dimension
Implementation/DBA Data:	APPS.EDW_ORGA_ORG_LCV

View Text

SELECT ORGANIZATION_PK
, OPERATING_UNIT_FK
, ORG_TREE1_LVL1_FK
, NAME
, ORGANIZATION_DP
, DATE_FROM
, DATE_TO
, BUSINESS_GROUP
, ORG_INT_EXT_FLAG
, ORG_TYPE
, ORG_CODE
, ORG_PRIM_CST_MTHD
, INSTANCE
, ORGANIZATION_ID
, LEVEL_NAME
, PERSON_MANAGER_ID
, PERSON_MANAGER_FK
, PERSON_MANAGER_FK_KEY
, ORG_CAT1
, ORG_CAT2
, ORG_CAT3
, ORG_CAT4
, ORG_CAT5
, ORG_CAT6
, ORG_CAT7
, ORG_CAT8
, ORG_CAT9
, ORG_CAT10
, ORG_CAT11
, ORG_CAT12
, ORG_CAT13
, ORG_CAT14
, ORG_CAT15
, LAST_UPDATE_DATE
, CREATION_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
FROM EDWBV_ORGA_ORG_LCV

Columns