1. Tables and Views for HCM
  2. HR_ORGANIZATION_UNITS

HR_ORGANIZATION_UNITS

Details

  • Schema: FUSION

  • Object owner: PER

  • Object type: VIEW

Columns

Name

ORGANIZATION_ID

ROW_ID

BUSINESS_GROUP_ID

COST_ALLOCATION_KEYFLEX_ID

LOCATION_ID

DATE_FROM

NAME

DATE_TO

INTERNAL_EXTERNAL_FLAG

INTERNAL_ADDRESS_LINE

TYPE

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

ATTRIBUTE16

ATTRIBUTE17

ATTRIBUTE18

ATTRIBUTE19

ATTRIBUTE20

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

CREATED_BY

CREATION_DATE

OBJECT_VERSION_NUMBER

ATTRIBUTE21

ATTRIBUTE22

ATTRIBUTE23

ATTRIBUTE24

ATTRIBUTE25

ATTRIBUTE26

ATTRIBUTE27

ATTRIBUTE28

ATTRIBUTE29

ATTRIBUTE30

ATTRIBUTE_NUMBER1

ATTRIBUTE_NUMBER2

ATTRIBUTE_NUMBER3

ATTRIBUTE_NUMBER4

ATTRIBUTE_NUMBER5

ATTRIBUTE_NUMBER6

ATTRIBUTE_NUMBER7

ATTRIBUTE_NUMBER8

ATTRIBUTE_NUMBER9

ATTRIBUTE_NUMBER10

ATTRIBUTE_NUMBER11

ATTRIBUTE_NUMBER12

ATTRIBUTE_NUMBER13

ATTRIBUTE_NUMBER14

ATTRIBUTE_NUMBER15

ATTRIBUTE_NUMBER16

ATTRIBUTE_NUMBER17

ATTRIBUTE_NUMBER18

ATTRIBUTE_NUMBER19

ATTRIBUTE_NUMBER20

ATTRIBUTE_DATE1

ATTRIBUTE_DATE2

ATTRIBUTE_DATE3

ATTRIBUTE_DATE4

ATTRIBUTE_DATE5

ATTRIBUTE_DATE6

ATTRIBUTE_DATE7

ATTRIBUTE_DATE8

ATTRIBUTE_DATE9

ATTRIBUTE_DATE10

ATTRIBUTE_DATE11

ATTRIBUTE_DATE12

ATTRIBUTE_DATE13

ATTRIBUTE_DATE14

ATTRIBUTE_DATE15

Query

SQL_Statement

SELECT

hao.ORGANIZATION_ID,

hao.ROWID,

hao.BUSINESS_GROUP_ID,

hao.COST_ALLOCATION_KEYFLEX_ID,

hao.LOCATION_ID,

hao.EFFECTIVE_START_DATE DATE_FROM,

haotl.NAME,

hao.EFFECTIVE_END_DATE DATE_TO,

hao.INTERNAL_EXTERNAL_FLAG,

hao.INTERNAL_ADDRESS_LINE,

hao.TYPE,

hao.ATTRIBUTE_CATEGORY,

hao.ATTRIBUTE1,

hao.ATTRIBUTE2,

hao.ATTRIBUTE3,

hao.ATTRIBUTE4,

hao.ATTRIBUTE5,

hao.ATTRIBUTE6,

hao.ATTRIBUTE7,

hao.ATTRIBUTE8,

hao.ATTRIBUTE9,

hao.ATTRIBUTE10,

hao.ATTRIBUTE11,

hao.ATTRIBUTE12,

hao.ATTRIBUTE13,

hao.ATTRIBUTE14,

hao.ATTRIBUTE15,

hao.ATTRIBUTE16,

hao.ATTRIBUTE17,

hao.ATTRIBUTE18,

hao.ATTRIBUTE19,

hao.ATTRIBUTE20,

hao.LAST_UPDATE_DATE,

hao.LAST_UPDATED_BY,

hao.LAST_UPDATE_LOGIN,

hao.CREATED_BY,

hao.CREATION_DATE,

hao.OBJECT_VERSION_NUMBER,

hao.ATTRIBUTE21,

hao.ATTRIBUTE22,

hao.ATTRIBUTE23,

hao.ATTRIBUTE24,

hao.ATTRIBUTE25,

hao.ATTRIBUTE26,

hao.ATTRIBUTE27,

hao.ATTRIBUTE28,

hao.ATTRIBUTE29,

hao.ATTRIBUTE30,

hao.ATTRIBUTE_NUMBER1,

hao.ATTRIBUTE_NUMBER2,

hao.ATTRIBUTE_NUMBER3,

hao.ATTRIBUTE_NUMBER4,

hao.ATTRIBUTE_NUMBER5,

hao.ATTRIBUTE_NUMBER6,

hao.ATTRIBUTE_NUMBER7,

hao.ATTRIBUTE_NUMBER8,

hao.ATTRIBUTE_NUMBER9,

hao.ATTRIBUTE_NUMBER10,

hao.ATTRIBUTE_NUMBER11,

hao.ATTRIBUTE_NUMBER12,

hao.ATTRIBUTE_NUMBER13,

hao.ATTRIBUTE_NUMBER14,

hao.ATTRIBUTE_NUMBER15,

hao.ATTRIBUTE_NUMBER16,

hao.ATTRIBUTE_NUMBER17,

hao.ATTRIBUTE_NUMBER18,

hao.ATTRIBUTE_NUMBER19,

hao.ATTRIBUTE_NUMBER20,

hao.ATTRIBUTE_DATE1,

hao.ATTRIBUTE_DATE2,

hao.ATTRIBUTE_DATE3,

hao.ATTRIBUTE_DATE4,

hao.ATTRIBUTE_DATE5,

hao.ATTRIBUTE_DATE6,

hao.ATTRIBUTE_DATE7,

hao.ATTRIBUTE_DATE8,

hao.ATTRIBUTE_DATE9,

hao.ATTRIBUTE_DATE10,

hao.ATTRIBUTE_DATE11,

hao.ATTRIBUTE_DATE12,

hao.ATTRIBUTE_DATE13,

hao.ATTRIBUTE_DATE14,

hao.ATTRIBUTE_DATE15

FROM

HR_ALL_ORGANIZATION_UNITS_F hao,

HR_ORGANIZATION_UNITS_F_TL haotl

WHERE

hao.ORGANIZATION_ID = haotl.ORGANIZATION_ID AND hao.EFFECTIVE_START_DATE = haotl.EFFECTIVE_START_DATE AND hao.EFFECTIVE_END_DATE = haotl.EFFECTIVE_END_DATE AND haotl.LANGUAGE = USERENV('LANG') AND TRUNC(SYSDATE) BETWEEN hao.EFFECTIVE_START_DATE AND hao.EFFECTIVE_END_DATE