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