HR_ORG_DETAILS_BY_CLASS

Details

Schema: FUSION
Object owner: PER
Object type: VIEW

Columns

Name
ORG_INFORMATION_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE ACTION_OCCURRENCE_ID ORGANIZATION_ID CLASSIFICATION_CODE LEGISLATION_CODE ORG_INFORMATION_CONTEXT ORG_INFORMATION1 ORG_INFORMATION2 ORG_INFORMATION3 ORG_INFORMATION4 ORG_INFORMATION5 ORG_INFORMATION6 ORG_INFORMATION7 ORG_INFORMATION8 ORG_INFORMATION9 ORG_INFORMATION10 ORG_INFORMATION11 ORG_INFORMATION12 ORG_INFORMATION13 ORG_INFORMATION14 ORG_INFORMATION15 ORG_INFORMATION16 ORG_INFORMATION17 ORG_INFORMATION18 ORG_INFORMATION19 ORG_INFORMATION20 ORG_INFORMATION21 ORG_INFORMATION22 ORG_INFORMATION23 ORG_INFORMATION24 ORG_INFORMATION25 ORG_INFORMATION26 ORG_INFORMATION27 ORG_INFORMATION28 ORG_INFORMATION29 ORG_INFORMATION30 ORG_INFORMATION_NUMBER1 ORG_INFORMATION_NUMBER2 ORG_INFORMATION_NUMBER3 ORG_INFORMATION_NUMBER4 ORG_INFORMATION_NUMBER5 ORG_INFORMATION_NUMBER6 ORG_INFORMATION_NUMBER7 ORG_INFORMATION_NUMBER8 ORG_INFORMATION_NUMBER9 ORG_INFORMATION_NUMBER10 ORG_INFORMATION_NUMBER11 ORG_INFORMATION_NUMBER12 ORG_INFORMATION_NUMBER13 ORG_INFORMATION_NUMBER14 ORG_INFORMATION_NUMBER15 ORG_INFORMATION_NUMBER16 ORG_INFORMATION_NUMBER17 ORG_INFORMATION_NUMBER18 ORG_INFORMATION_NUMBER19 ORG_INFORMATION_NUMBER20 ORG_INFORMATION_DATE1 ORG_INFORMATION_DATE2 ORG_INFORMATION_DATE3 ORG_INFORMATION_DATE4 ORG_INFORMATION_DATE5 ORG_INFORMATION_DATE6 ORG_INFORMATION_DATE7 ORG_INFORMATION_DATE8 ORG_INFORMATION_DATE9 ORG_INFORMATION_DATE10 ORG_INFORMATION_DATE11 ORG_INFORMATION_DATE12 ORG_INFORMATION_DATE13 ORG_INFORMATION_DATE14 ORG_INFORMATION_DATE15 ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 ATTRIBUTE21 ATTRIBUTE22 ATTRIBUTE23 ATTRIBUTE24 ATTRIBUTE25 ATTRIBUTE26 ATTRIBUTE27 ATTRIBUTE28 ATTRIBUTE29 ATTRIBUTE30 OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN SEQUENCE_NUMBER BUSINESS_GROUP_ID

Name

ORG_INFORMATION_ID

EFFECTIVE_START_DATE

EFFECTIVE_END_DATE

ACTION_OCCURRENCE_ID

ORGANIZATION_ID

CLASSIFICATION_CODE

LEGISLATION_CODE

ORG_INFORMATION_CONTEXT

ORG_INFORMATION1

ORG_INFORMATION2

ORG_INFORMATION3

ORG_INFORMATION4

ORG_INFORMATION5

ORG_INFORMATION6

ORG_INFORMATION7

ORG_INFORMATION8

ORG_INFORMATION9

ORG_INFORMATION10

ORG_INFORMATION11

ORG_INFORMATION12

ORG_INFORMATION13

ORG_INFORMATION14

ORG_INFORMATION15

ORG_INFORMATION16

ORG_INFORMATION17

ORG_INFORMATION18

ORG_INFORMATION19

ORG_INFORMATION20

ORG_INFORMATION21

ORG_INFORMATION22

ORG_INFORMATION23

ORG_INFORMATION24

ORG_INFORMATION25

ORG_INFORMATION26

ORG_INFORMATION27

ORG_INFORMATION28

ORG_INFORMATION29

ORG_INFORMATION30

ORG_INFORMATION_NUMBER1

ORG_INFORMATION_NUMBER2

ORG_INFORMATION_NUMBER3

ORG_INFORMATION_NUMBER4

ORG_INFORMATION_NUMBER5

ORG_INFORMATION_NUMBER6

ORG_INFORMATION_NUMBER7

ORG_INFORMATION_NUMBER8

ORG_INFORMATION_NUMBER9

ORG_INFORMATION_NUMBER10

ORG_INFORMATION_NUMBER11

ORG_INFORMATION_NUMBER12

ORG_INFORMATION_NUMBER13

ORG_INFORMATION_NUMBER14

ORG_INFORMATION_NUMBER15

ORG_INFORMATION_NUMBER16

ORG_INFORMATION_NUMBER17

ORG_INFORMATION_NUMBER18

ORG_INFORMATION_NUMBER19

ORG_INFORMATION_NUMBER20

ORG_INFORMATION_DATE1

ORG_INFORMATION_DATE2

ORG_INFORMATION_DATE3

ORG_INFORMATION_DATE4

ORG_INFORMATION_DATE5

ORG_INFORMATION_DATE6

ORG_INFORMATION_DATE7

ORG_INFORMATION_DATE8

ORG_INFORMATION_DATE9

ORG_INFORMATION_DATE10

ORG_INFORMATION_DATE11

ORG_INFORMATION_DATE12

ORG_INFORMATION_DATE13

ORG_INFORMATION_DATE14

ORG_INFORMATION_DATE15

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

ATTRIBUTE16

ATTRIBUTE17

ATTRIBUTE18

ATTRIBUTE19

ATTRIBUTE20

ATTRIBUTE21

ATTRIBUTE22

ATTRIBUTE23

ATTRIBUTE24

ATTRIBUTE25

ATTRIBUTE26

ATTRIBUTE27

ATTRIBUTE28

ATTRIBUTE29

ATTRIBUTE30

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

SEQUENCE_NUMBER

BUSINESS_GROUP_ID

Query

SQL_Statement
SELECT oua.ORG_INFORMATION_ID, oua.EFFECTIVE_START_DATE, oua.EFFECTIVE_END_DATE, oua.ACTION_OCCURRENCE_ID, oua.ORGANIZATION_ID, oibc.CLASSIFICATION_CODE, oua.LEGISLATION_CODE, oua.ORG_INFORMATION_CONTEXT, oua.ORG_INFORMATION1, oua.ORG_INFORMATION2, oua.ORG_INFORMATION3, oua.ORG_INFORMATION4, oua.ORG_INFORMATION5, oua.ORG_INFORMATION6, oua.ORG_INFORMATION7, oua.ORG_INFORMATION8, oua.ORG_INFORMATION9, oua.ORG_INFORMATION10, oua.ORG_INFORMATION11, oua.ORG_INFORMATION12, oua.ORG_INFORMATION13, oua.ORG_INFORMATION14, oua.ORG_INFORMATION15, oua.ORG_INFORMATION16, oua.ORG_INFORMATION17, oua.ORG_INFORMATION18, oua.ORG_INFORMATION19, oua.ORG_INFORMATION20, oua.ORG_INFORMATION21, oua.ORG_INFORMATION22, oua.ORG_INFORMATION23, oua.ORG_INFORMATION24, oua.ORG_INFORMATION25, oua.ORG_INFORMATION26, oua.ORG_INFORMATION27, oua.ORG_INFORMATION28, oua.ORG_INFORMATION29, oua.ORG_INFORMATION30, oua.ORG_INFORMATION_NUMBER1, oua.ORG_INFORMATION_NUMBER2, oua.ORG_INFORMATION_NUMBER3, oua.ORG_INFORMATION_NUMBER4, oua.ORG_INFORMATION_NUMBER5, oua.ORG_INFORMATION_NUMBER6, oua.ORG_INFORMATION_NUMBER7, oua.ORG_INFORMATION_NUMBER8, oua.ORG_INFORMATION_NUMBER9, oua.ORG_INFORMATION_NUMBER10, oua.ORG_INFORMATION_NUMBER11, oua.ORG_INFORMATION_NUMBER12, oua.ORG_INFORMATION_NUMBER13, oua.ORG_INFORMATION_NUMBER14, oua.ORG_INFORMATION_NUMBER15, oua.ORG_INFORMATION_NUMBER16, oua.ORG_INFORMATION_NUMBER17, oua.ORG_INFORMATION_NUMBER18, oua.ORG_INFORMATION_NUMBER19, oua.ORG_INFORMATION_NUMBER20, oua.ORG_INFORMATION_DATE1, oua.ORG_INFORMATION_DATE2, oua.ORG_INFORMATION_DATE3, oua.ORG_INFORMATION_DATE4, oua.ORG_INFORMATION_DATE5, oua.ORG_INFORMATION_DATE6, oua.ORG_INFORMATION_DATE7, oua.ORG_INFORMATION_DATE8, oua.ORG_INFORMATION_DATE9, oua.ORG_INFORMATION_DATE10, oua.ORG_INFORMATION_DATE11, oua.ORG_INFORMATION_DATE12, oua.ORG_INFORMATION_DATE13, oua.ORG_INFORMATION_DATE14, oua.ORG_INFORMATION_DATE15, oua.ATTRIBUTE_CATEGORY, oua.ATTRIBUTE1, oua.ATTRIBUTE2, oua.ATTRIBUTE3, oua.ATTRIBUTE4, oua.ATTRIBUTE5, oua.ATTRIBUTE6, oua.ATTRIBUTE7, oua.ATTRIBUTE8, oua.ATTRIBUTE9, oua.ATTRIBUTE10, oua.ATTRIBUTE11, oua.ATTRIBUTE12, oua.ATTRIBUTE13, oua.ATTRIBUTE14, oua.ATTRIBUTE15, oua.ATTRIBUTE16, oua.ATTRIBUTE17, oua.ATTRIBUTE18, oua.ATTRIBUTE19, oua.ATTRIBUTE20, oua.ATTRIBUTE21, oua.ATTRIBUTE22, oua.ATTRIBUTE23, oua.ATTRIBUTE24, oua.ATTRIBUTE25, oua.ATTRIBUTE26, oua.ATTRIBUTE27, oua.ATTRIBUTE28, oua.ATTRIBUTE29, oua.ATTRIBUTE30, oua.OBJECT_VERSION_NUMBER, oua.CREATED_BY, oua.CREATION_DATE, oua.LAST_UPDATED_BY, oua.LAST_UPDATE_DATE, oua.LAST_UPDATE_LOGIN, oua.SEQUENCE_NUMBER, oua.BUSINESS_GROUP_ID FROM HR_ORGANIZATION_INFORMATION_F oua, HR_ORG_INFO_TYPES_BY_CLASS oibc WHERE oibc.ORG_INFORMATION_TYPE = oua.ORG_INFORMATION_CONTEXT

SQL_Statement

SELECT

oua.ORG_INFORMATION_ID,

oua.EFFECTIVE_START_DATE,

oua.EFFECTIVE_END_DATE,

oua.ACTION_OCCURRENCE_ID,

oua.ORGANIZATION_ID,

oibc.CLASSIFICATION_CODE,

oua.LEGISLATION_CODE,

oua.ORG_INFORMATION_CONTEXT,

oua.ORG_INFORMATION1,

oua.ORG_INFORMATION2,

oua.ORG_INFORMATION3,

oua.ORG_INFORMATION4,

oua.ORG_INFORMATION5,

oua.ORG_INFORMATION6,

oua.ORG_INFORMATION7,

oua.ORG_INFORMATION8,

oua.ORG_INFORMATION9,

oua.ORG_INFORMATION10,

oua.ORG_INFORMATION11,

oua.ORG_INFORMATION12,

oua.ORG_INFORMATION13,

oua.ORG_INFORMATION14,

oua.ORG_INFORMATION15,

oua.ORG_INFORMATION16,

oua.ORG_INFORMATION17,

oua.ORG_INFORMATION18,

oua.ORG_INFORMATION19,

oua.ORG_INFORMATION20,

oua.ORG_INFORMATION21,

oua.ORG_INFORMATION22,

oua.ORG_INFORMATION23,

oua.ORG_INFORMATION24,

oua.ORG_INFORMATION25,

oua.ORG_INFORMATION26,

oua.ORG_INFORMATION27,

oua.ORG_INFORMATION28,

oua.ORG_INFORMATION29,

oua.ORG_INFORMATION30,

oua.ORG_INFORMATION_NUMBER1,

oua.ORG_INFORMATION_NUMBER2,

oua.ORG_INFORMATION_NUMBER3,

oua.ORG_INFORMATION_NUMBER4,

oua.ORG_INFORMATION_NUMBER5,

oua.ORG_INFORMATION_NUMBER6,

oua.ORG_INFORMATION_NUMBER7,

oua.ORG_INFORMATION_NUMBER8,

oua.ORG_INFORMATION_NUMBER9,

oua.ORG_INFORMATION_NUMBER10,

oua.ORG_INFORMATION_NUMBER11,

oua.ORG_INFORMATION_NUMBER12,

oua.ORG_INFORMATION_NUMBER13,

oua.ORG_INFORMATION_NUMBER14,

oua.ORG_INFORMATION_NUMBER15,

oua.ORG_INFORMATION_NUMBER16,

oua.ORG_INFORMATION_NUMBER17,

oua.ORG_INFORMATION_NUMBER18,

oua.ORG_INFORMATION_NUMBER19,

oua.ORG_INFORMATION_NUMBER20,

oua.ORG_INFORMATION_DATE1,

oua.ORG_INFORMATION_DATE2,

oua.ORG_INFORMATION_DATE3,

oua.ORG_INFORMATION_DATE4,

oua.ORG_INFORMATION_DATE5,

oua.ORG_INFORMATION_DATE6,

oua.ORG_INFORMATION_DATE7,

oua.ORG_INFORMATION_DATE8,

oua.ORG_INFORMATION_DATE9,

oua.ORG_INFORMATION_DATE10,

oua.ORG_INFORMATION_DATE11,

oua.ORG_INFORMATION_DATE12,

oua.ORG_INFORMATION_DATE13,

oua.ORG_INFORMATION_DATE14,

oua.ORG_INFORMATION_DATE15,

oua.ATTRIBUTE_CATEGORY,

oua.ATTRIBUTE1,

oua.ATTRIBUTE2,

oua.ATTRIBUTE3,

oua.ATTRIBUTE4,

oua.ATTRIBUTE5,

oua.ATTRIBUTE6,

oua.ATTRIBUTE7,

oua.ATTRIBUTE8,

oua.ATTRIBUTE9,

oua.ATTRIBUTE10,

oua.ATTRIBUTE11,

oua.ATTRIBUTE12,

oua.ATTRIBUTE13,

oua.ATTRIBUTE14,

oua.ATTRIBUTE15,

oua.ATTRIBUTE16,

oua.ATTRIBUTE17,

oua.ATTRIBUTE18,

oua.ATTRIBUTE19,

oua.ATTRIBUTE20,

oua.ATTRIBUTE21,

oua.ATTRIBUTE22,

oua.ATTRIBUTE23,

oua.ATTRIBUTE24,

oua.ATTRIBUTE25,

oua.ATTRIBUTE26,

oua.ATTRIBUTE27,

oua.ATTRIBUTE28,

oua.ATTRIBUTE29,

oua.ATTRIBUTE30,

oua.OBJECT_VERSION_NUMBER,

oua.CREATED_BY,

oua.CREATION_DATE,

oua.LAST_UPDATED_BY,

oua.LAST_UPDATE_DATE,

oua.LAST_UPDATE_LOGIN,

oua.SEQUENCE_NUMBER,

oua.BUSINESS_GROUP_ID

FROM

HR_ORGANIZATION_INFORMATION_F oua,

HR_ORG_INFO_TYPES_BY_CLASS oibc

WHERE

oibc.ORG_INFORMATION_TYPE = oua.ORG_INFORMATION_CONTEXT