VIEW: HR.HR_DE_ORGANIZATION_LINKS#

Source

View Text - Preformatted

select ORGANIZATION_LINK_ID ORGANIZATION_LINK_ID, PARENT_ORGANIZATION_ID PARENT_ORGANIZATION_ID, CHILD_ORGANIZATION_ID CHILD_ORGANIZATION_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, ORG_LINK_TYPE ORG_LINK_TYPE, ORG_LINK_INFORMATION_CATEGORY ORG_LINK_INFORMATION_CATEGORY, ORG_LINK_INFORMATION1 ORG_LINK_INFORMATION1, ORG_LINK_INFORMATION2 ORG_LINK_INFORMATION2, ORG_LINK_INFORMATION3 ORG_LINK_INFORMATION3, ORG_LINK_INFORMATION4 ORG_LINK_INFORMATION4, ORG_LINK_INFORMATION5 ORG_LINK_INFORMATION5, ORG_LINK_INFORMATION6 ORG_LINK_INFORMATION6, ORG_LINK_INFORMATION7 ORG_LINK_INFORMATION7, ORG_LINK_INFORMATION8 ORG_LINK_INFORMATION8, ORG_LINK_INFORMATION9 ORG_LINK_INFORMATION9, ORG_LINK_INFORMATION10 ORG_LINK_INFORMATION10, ORG_LINK_INFORMATION11 ORG_LINK_INFORMATION11, ORG_LINK_INFORMATION12 ORG_LINK_INFORMATION12, ORG_LINK_INFORMATION13 ORG_LINK_INFORMATION13, ORG_LINK_INFORMATION14 ORG_LINK_INFORMATION14, ORG_LINK_INFORMATION15 ORG_LINK_INFORMATION15, ORG_LINK_INFORMATION16 ORG_LINK_INFORMATION16, ORG_LINK_INFORMATION17 ORG_LINK_INFORMATION17, ORG_LINK_INFORMATION18 ORG_LINK_INFORMATION18, ORG_LINK_INFORMATION19 ORG_LINK_INFORMATION19, ORG_LINK_INFORMATION20 ORG_LINK_INFORMATION20, ORG_LINK_INFORMATION21 ORG_LINK_INFORMATION21, ORG_LINK_INFORMATION22 ORG_LINK_INFORMATION22, ORG_LINK_INFORMATION23 ORG_LINK_INFORMATION23, ORG_LINK_INFORMATION24 ORG_LINK_INFORMATION24, ORG_LINK_INFORMATION25 ORG_LINK_INFORMATION25, ORG_LINK_INFORMATION26 ORG_LINK_INFORMATION26, ORG_LINK_INFORMATION27 ORG_LINK_INFORMATION27, ORG_LINK_INFORMATION28 ORG_LINK_INFORMATION28, ORG_LINK_INFORMATION29 ORG_LINK_INFORMATION29, ORG_LINK_INFORMATION30 ORG_LINK_INFORMATION30, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, ATTRIBUTE21 ATTRIBUTE21, ATTRIBUTE22 ATTRIBUTE22, ATTRIBUTE23 ATTRIBUTE23, ATTRIBUTE24 ATTRIBUTE24, ATTRIBUTE25 ATTRIBUTE25, ATTRIBUTE26 ATTRIBUTE26, ATTRIBUTE27 ATTRIBUTE27, ATTRIBUTE28 ATTRIBUTE28, ATTRIBUTE29 ATTRIBUTE29, ATTRIBUTE30 ATTRIBUTE30, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "HR"."HR_DE_ORGANIZATION_LINKS"

View Text - HTML Formatted

SELECT ORGANIZATION_LINK_ID ORGANIZATION_LINK_ID
, PARENT_ORGANIZATION_ID PARENT_ORGANIZATION_ID
, CHILD_ORGANIZATION_ID CHILD_ORGANIZATION_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ORG_LINK_TYPE ORG_LINK_TYPE
, ORG_LINK_INFORMATION_CATEGORY ORG_LINK_INFORMATION_CATEGORY
, ORG_LINK_INFORMATION1 ORG_LINK_INFORMATION1
, ORG_LINK_INFORMATION2 ORG_LINK_INFORMATION2
, ORG_LINK_INFORMATION3 ORG_LINK_INFORMATION3
, ORG_LINK_INFORMATION4 ORG_LINK_INFORMATION4
, ORG_LINK_INFORMATION5 ORG_LINK_INFORMATION5
, ORG_LINK_INFORMATION6 ORG_LINK_INFORMATION6
, ORG_LINK_INFORMATION7 ORG_LINK_INFORMATION7
, ORG_LINK_INFORMATION8 ORG_LINK_INFORMATION8
, ORG_LINK_INFORMATION9 ORG_LINK_INFORMATION9
, ORG_LINK_INFORMATION10 ORG_LINK_INFORMATION10
, ORG_LINK_INFORMATION11 ORG_LINK_INFORMATION11
, ORG_LINK_INFORMATION12 ORG_LINK_INFORMATION12
, ORG_LINK_INFORMATION13 ORG_LINK_INFORMATION13
, ORG_LINK_INFORMATION14 ORG_LINK_INFORMATION14
, ORG_LINK_INFORMATION15 ORG_LINK_INFORMATION15
, ORG_LINK_INFORMATION16 ORG_LINK_INFORMATION16
, ORG_LINK_INFORMATION17 ORG_LINK_INFORMATION17
, ORG_LINK_INFORMATION18 ORG_LINK_INFORMATION18
, ORG_LINK_INFORMATION19 ORG_LINK_INFORMATION19
, ORG_LINK_INFORMATION20 ORG_LINK_INFORMATION20
, ORG_LINK_INFORMATION21 ORG_LINK_INFORMATION21
, ORG_LINK_INFORMATION22 ORG_LINK_INFORMATION22
, ORG_LINK_INFORMATION23 ORG_LINK_INFORMATION23
, ORG_LINK_INFORMATION24 ORG_LINK_INFORMATION24
, ORG_LINK_INFORMATION25 ORG_LINK_INFORMATION25
, ORG_LINK_INFORMATION26 ORG_LINK_INFORMATION26
, ORG_LINK_INFORMATION27 ORG_LINK_INFORMATION27
, ORG_LINK_INFORMATION28 ORG_LINK_INFORMATION28
, ORG_LINK_INFORMATION29 ORG_LINK_INFORMATION29
, ORG_LINK_INFORMATION30 ORG_LINK_INFORMATION30
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, ATTRIBUTE21 ATTRIBUTE21
, ATTRIBUTE22 ATTRIBUTE22
, ATTRIBUTE23 ATTRIBUTE23
, ATTRIBUTE24 ATTRIBUTE24
, ATTRIBUTE25 ATTRIBUTE25
, ATTRIBUTE26 ATTRIBUTE26
, ATTRIBUTE27 ATTRIBUTE27
, ATTRIBUTE28 ATTRIBUTE28
, ATTRIBUTE29 ATTRIBUTE29
, ATTRIBUTE30 ATTRIBUTE30
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "HR"."HR_DE_ORGANIZATION_LINKS"