PER_DEPARTMENTS

Details

  • Schema: FUSION

  • Object owner: PER

  • Object type: VIEW

Columns

Name

ORGANIZATION_ID

EFFECTIVE_START_DATE

EFFECTIVE_END_DATE

BUSINESS_GROUP_ID

LOCATION_ID

SET_ID

NAME

TITLE

STATUS

TYPE

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

ORGANIZATION_CODE

Query

SQL_Statement

SELECT

hao.ORGANIZATION_ID,

hao.EFFECTIVE_START_DATE,

hao.EFFECTIVE_END_DATE,

hao.BUSINESS_GROUP_ID,

hao.LOCATION_ID,

hac.SET_ID,

haotl.NAME,

haotl.TITLE,

hac.STATUS,

hao.TYPE,

hac.OBJECT_VERSION_NUMBER,

hac.CREATED_BY,

hac.CREATION_DATE,

hac.LAST_UPDATED_BY,

hac.LAST_UPDATE_DATE,

hac.LAST_UPDATE_LOGIN,

hao.ORGANIZATION_CODE

FROM

HR_ORG_UNIT_CLASSIFICATIONS_F hac,

HR_ALL_ORGANIZATION_UNITS_F hao,

HR_ORGANIZATION_UNITS_F_TL haotl

WHERE

hao.ORGANIZATION_ID = hac.ORGANIZATION_ID AND hao.ORGANIZATION_ID = haotl.ORGANIZATION_ID AND hao.EFFECTIVE_START_DATE BETWEEN hac.EFFECTIVE_START_DATE AND hac.EFFECTIVE_END_DATE AND haotl.LANGUAGE = USERENV('LANG') AND haotl.EFFECTIVE_START_DATE = hao.EFFECTIVE_START_DATE AND haotl.EFFECTIVE_END_DATE = hao.EFFECTIVE_END_DATE AND hac.CLASSIFICATION_CODE = 'DEPARTMENT'