View: HR_ORGANIZATION_INFORMATION_V

Product:	PER - Human Resources
Description:	Used to support user interface
Implementation/DBA Data:	APPS.HR_ORGANIZATION_INFORMATION_V

View Text

SELECT I.ORG_INFORMATION_ID
, I.ROWID
, HL.MEANING
, HL2.MEANING
, I.ORG_INFORMATION_CONTEXT
, I.ORGANIZATION_ID
, I.ORG_INFORMATION1
, I.ORG_INFORMATION10
, I.ORG_INFORMATION11
, I.ORG_INFORMATION12
, I.ORG_INFORMATION13
, I.ORG_INFORMATION14
, I.ORG_INFORMATION15
, I.ORG_INFORMATION16
, I.ORG_INFORMATION17
, I.ORG_INFORMATION18
, I.ORG_INFORMATION19
, I.ORG_INFORMATION2
, I.ORG_INFORMATION20
, I.ORG_INFORMATION3
, I.ORG_INFORMATION4
, I.ORG_INFORMATION5
, I.ORG_INFORMATION6
, I.ORG_INFORMATION7
, I.ORG_INFORMATION8
, I.ORG_INFORMATION9
, I.REQUEST_ID
, I.PROGRAM_APPLICATION_ID
, I.PROGRAM_ID
, I.PROGRAM_UPDATE_DATE
, I.ATTRIBUTE_CATEGORY
, I.ATTRIBUTE1
, I.ATTRIBUTE2
, I.ATTRIBUTE3
, I.ATTRIBUTE4
, I.ATTRIBUTE5
, I.ATTRIBUTE6
, I.ATTRIBUTE7
, I.ATTRIBUTE8
, I.ATTRIBUTE9
, I.ATTRIBUTE10
, I.ATTRIBUTE11
, I.ATTRIBUTE12
, I.ATTRIBUTE13
, I.ATTRIBUTE14
, I.ATTRIBUTE15
, I.ATTRIBUTE16
, I.ATTRIBUTE17
, I.ATTRIBUTE18
, I.ATTRIBUTE19
, I.ATTRIBUTE20
, I.LAST_UPDATE_DATE
, I.LAST_UPDATED_BY
, I.LAST_UPDATE_LOGIN
, I.CREATED_BY
, I.CREATION_DATE
, I.OBJECT_VERSION_NUMBER
FROM HR_ORGANIZATION_INFORMATION I
, HR_LOOKUPS HL
, HR_LOOKUPS HL2
WHERE I.ORG_INFORMATION1 = HL.LOOKUP_CODE (+)
AND HL.LOOKUP_TYPE (+) = 'ORG_CLASS'
AND I.ORG_INFORMATION2 = HL2.LOOKUP_CODE (+)
AND HL2.LOOKUP_TYPE (+) = 'YES_NO'

Columns