VIEW: APPS.HR_ORGANIZATION_INFORMATION_V1

Source

View Text - Preformatted

SELECT I.ORG_INFORMATION_ID , I.ROWID , HL.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 ,to_number( I.ORG_INFORMATION7) , substr(hr_de_general.get_tax_office_details(to_number(I.org_information7)),1,4), substr(hr_de_general.get_tax_office_details(to_number(I.org_information7)),5,240), 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, OBJECT_VERSION_NUMBER FROM HR_ORGANIZATION_INFORMATION I, HR_LOOKUPS HL, FND_SESSIONS SES WHERE I.ORG_INFORMATION6 = HL.LOOKUP_CODE (+) AND HL.LOOKUP_TYPE (+) = 'YES_NO' AND I.ORG_INFORMATION_CONTEXT = 'DE_HR_ORG_INFO' AND SES.session_id = userenv('SESSIONID')

View Text - HTML Formatted

SELECT I.ORG_INFORMATION_ID
, I.ROWID
, HL.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
, TO_NUMBER( I.ORG_INFORMATION7)
, SUBSTR(HR_DE_GENERAL.GET_TAX_OFFICE_DETAILS(TO_NUMBER(I.ORG_INFORMATION7))
, 1
, 4)
, SUBSTR(HR_DE_GENERAL.GET_TAX_OFFICE_DETAILS(TO_NUMBER(I.ORG_INFORMATION7))
, 5
, 240)
, 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
, OBJECT_VERSION_NUMBER
FROM HR_ORGANIZATION_INFORMATION I
, HR_LOOKUPS HL
, FND_SESSIONS SES
WHERE I.ORG_INFORMATION6 = HL.LOOKUP_CODE (+)
AND HL.LOOKUP_TYPE (+) = 'YES_NO'
AND I.ORG_INFORMATION_CONTEXT = 'DE_HR_ORG_INFO'
AND SES.SESSION_ID = USERENV('SESSIONID')