VIEW: APPS.HR_DE_ORGANIZATION_LINKS_V2

Source

View Text - Preformatted

SELECT orl.organization_link_id, orl.parent_organization_id, org1.name, orl.child_organization_id, org2.name, orl.business_group_id, orl.org_link_type, orl.org_link_information_category, orl.org_link_information1, SUBSTR(hr_general.decode_lookup('DE_LIABILITY_PROVIDER_STATUS', orl.org_link_information1), 1, 80), orl.org_link_information2, orl.org_link_information3, orl.org_link_information4, orl.org_link_information5, orl.org_link_information6, orl.org_link_information7, orl.org_link_information8, orl.org_link_information9, orl.org_link_information10, orl.org_link_information11, orl.org_link_information12, orl.org_link_information13, orl.org_link_information14, orl.org_link_information15, orl.org_link_information16, orl.org_link_information17, orl.org_link_information18, orl.org_link_information19, orl.org_link_information20, orl.org_link_information21, orl.org_link_information22, orl.org_link_information23, orl.org_link_information24, orl.org_link_information25, orl.org_link_information26, orl.org_link_information27, orl.org_link_information28, orl.org_link_information29, orl.org_link_information30, orl.attribute_category, orl.attribute1, orl.attribute2, orl.attribute3, orl.attribute4, orl.attribute5, orl.attribute6, orl.attribute7, orl.attribute8, orl.attribute9, orl.attribute10, orl.attribute11, orl.attribute12, orl.attribute13, orl.attribute14, orl.attribute15, orl.attribute16, orl.attribute17, orl.attribute18, orl.attribute19, orl.attribute20, orl.attribute21, orl.attribute22, orl.attribute23, orl.attribute24, orl.attribute25, orl.attribute26, orl.attribute27, orl.attribute28, orl.attribute29, orl.attribute30, orl.last_update_date, orl.last_updated_by, orl.last_update_login, orl.created_by, orl.creation_date, orl.object_version_number FROM hr_de_organization_links ORL ,hr_all_organization_units ORG1 ,hr_all_organization_units ORG2 ,fnd_sessions SES WHERE orl.parent_organization_id = org1.organization_id (+) AND orl.child_organization_id = org2.organization_id (+) AND ses.session_id = userenv('SESSIONID') AND orl.org_link_type = 'DE_LIABILITY_INSURANCE'

View Text - HTML Formatted

SELECT ORL.ORGANIZATION_LINK_ID
, ORL.PARENT_ORGANIZATION_ID
, ORG1.NAME
, ORL.CHILD_ORGANIZATION_ID
, ORG2.NAME
, ORL.BUSINESS_GROUP_ID
, ORL.ORG_LINK_TYPE
, ORL.ORG_LINK_INFORMATION_CATEGORY
, ORL.ORG_LINK_INFORMATION1
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('DE_LIABILITY_PROVIDER_STATUS'
, ORL.ORG_LINK_INFORMATION1)
, 1
, 80)
, ORL.ORG_LINK_INFORMATION2
, ORL.ORG_LINK_INFORMATION3
, ORL.ORG_LINK_INFORMATION4
, ORL.ORG_LINK_INFORMATION5
, ORL.ORG_LINK_INFORMATION6
, ORL.ORG_LINK_INFORMATION7
, ORL.ORG_LINK_INFORMATION8
, ORL.ORG_LINK_INFORMATION9
, ORL.ORG_LINK_INFORMATION10
, ORL.ORG_LINK_INFORMATION11
, ORL.ORG_LINK_INFORMATION12
, ORL.ORG_LINK_INFORMATION13
, ORL.ORG_LINK_INFORMATION14
, ORL.ORG_LINK_INFORMATION15
, ORL.ORG_LINK_INFORMATION16
, ORL.ORG_LINK_INFORMATION17
, ORL.ORG_LINK_INFORMATION18
, ORL.ORG_LINK_INFORMATION19
, ORL.ORG_LINK_INFORMATION20
, ORL.ORG_LINK_INFORMATION21
, ORL.ORG_LINK_INFORMATION22
, ORL.ORG_LINK_INFORMATION23
, ORL.ORG_LINK_INFORMATION24
, ORL.ORG_LINK_INFORMATION25
, ORL.ORG_LINK_INFORMATION26
, ORL.ORG_LINK_INFORMATION27
, ORL.ORG_LINK_INFORMATION28
, ORL.ORG_LINK_INFORMATION29
, ORL.ORG_LINK_INFORMATION30
, ORL.ATTRIBUTE_CATEGORY
, ORL.ATTRIBUTE1
, ORL.ATTRIBUTE2
, ORL.ATTRIBUTE3
, ORL.ATTRIBUTE4
, ORL.ATTRIBUTE5
, ORL.ATTRIBUTE6
, ORL.ATTRIBUTE7
, ORL.ATTRIBUTE8
, ORL.ATTRIBUTE9
, ORL.ATTRIBUTE10
, ORL.ATTRIBUTE11
, ORL.ATTRIBUTE12
, ORL.ATTRIBUTE13
, ORL.ATTRIBUTE14
, ORL.ATTRIBUTE15
, ORL.ATTRIBUTE16
, ORL.ATTRIBUTE17
, ORL.ATTRIBUTE18
, ORL.ATTRIBUTE19
, ORL.ATTRIBUTE20
, ORL.ATTRIBUTE21
, ORL.ATTRIBUTE22
, ORL.ATTRIBUTE23
, ORL.ATTRIBUTE24
, ORL.ATTRIBUTE25
, ORL.ATTRIBUTE26
, ORL.ATTRIBUTE27
, ORL.ATTRIBUTE28
, ORL.ATTRIBUTE29
, ORL.ATTRIBUTE30
, ORL.LAST_UPDATE_DATE
, ORL.LAST_UPDATED_BY
, ORL.LAST_UPDATE_LOGIN
, ORL.CREATED_BY
, ORL.CREATION_DATE
, ORL.OBJECT_VERSION_NUMBER
FROM HR_DE_ORGANIZATION_LINKS ORL
, HR_ALL_ORGANIZATION_UNITS ORG1
, HR_ALL_ORGANIZATION_UNITS ORG2
, FND_SESSIONS SES
WHERE ORL.PARENT_ORGANIZATION_ID = ORG1.ORGANIZATION_ID (+)
AND ORL.CHILD_ORGANIZATION_ID = ORG2.ORGANIZATION_ID (+)
AND SES.SESSION_ID = USERENV('SESSIONID')
AND ORL.ORG_LINK_TYPE = 'DE_LIABILITY_INSURANCE'