Product: | PER - Human Resources |
---|---|
Description: | German HR Organization information view for ORG_INFORMATION_CONTEXT = 'DE_HR_ORG_INFO' |
Implementation/DBA Data: | APPS.HR_ORGANIZATION_INFORMATION_V1 |
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')