VIEW: APPS.HR_ORGANIZATION_INFORMATION_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'