FUN_ORGANIZATIONS_V

Details

• Schema: FUSION

• Object owner: FUN

• Object type: VIEW

Columns

Name
BU_ID BU_NAME BUSINESS_GROUP_ID DATE_FROM DATE_TO CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT ORG.ORGANIZATION_ID BU_ID, ORG.NAME BU_NAME, ORG.BUSINESS_GROUP_ID BUSINESS_GROUP_ID, ORG.EFFECTIVE_START_DATE DATE_FROM, ORG.EFFECTIVE_END_DATE DATE_TO, ORG.CREATED_BY CREATED_BY, ORG.CREATION_DATE CREATION_DATE, ORG.LAST_UPDATED_BY LAST_UPDATED_BY, ORG.LAST_UPDATE_DATE LAST_UPDATE_DATE, ORG.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM HR_ORGANIZATION_UNITS_F_TL ORG WHERE TRUNC(SYSDATE) BETWEEN ORG.EFFECTIVE_START_DATE AND ORG.EFFECTIVE_END_DATE AND ORG.LANGUAGE = USERENV('LANG')