CN_BUSINESS_UNITS_NAMES_X
Details
-
Schema: FUSION
-
Object owner: CN
-
Object type: VIEW
Columns
Name |
---|
ORGANIZATION_ID NAME LANGUAGE SOURCE_LANG EFFECTIVE_START_DATE EFFECTIVE_END_DATE LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN |
Query
SQL_Statement |
---|
SELECT ORG.ORGANIZATION_ID, ORG.NAME, ORG.LANGUAGE, ORG.SOURCE_LANG, ORG.EFFECTIVE_START_DATE, ORG.EFFECTIVE_END_DATE, ORG.LAST_UPDATE_DATE, ORG.LAST_UPDATED_BY, ORG.CREATION_DATE, ORG.CREATED_BY, ORG.LAST_UPDATE_LOGIN FROM hr_organization_units_f_tl ORG, HR_ORG_UNIT_CLASSIFICATIONS_X CLS WHERE CLS.ORGANIZATION_ID = ORG.ORGANIZATION_ID AND CLS.CLASSIFICATION_CODE = 'FUN_BUSINESS_UNIT' AND TRUNC(SYSDATE) BETWEEN ORG.EFFECTIVE_START_DATE AND ORG.EFFECTIVE_END_DATE |