Product: | PER - Human Resources |
---|---|
Description: | Displays all other misc links for an Internal organization |
Implementation/DBA Data: | APPS.HR_DE_ORGANIZATION_LINKS_V3 |
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
, ( SUBSTR(HR_GENERAL.DECODE_LOOKUP('DE_LINK_TYPE'
, ORL.ORG_LINK_TYPE)
, 1
, 80) ) D_LINK_TYPE
, 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 IN (SELECT LOOKUP_CODE
FROM HR_LEG_LOOKUPS
WHERE LOOKUP_TYPE = 'DE_LINK_TYPE' MINUS SELECT LOOKUP_CODE
FROM HR_LEG_LOOKUPS
WHERE LOOKUP_TYPE = 'DE_LEGMAINT_LINK_TYPE')