SELECT ROWID, ORG_LINK_INFORMATION_CATEGORY, ORG_LINK_INFORMATION1, (DECODE (ORG_LINK_INFORMATION_CATEGORY, 'DE_LIABILITY_INSURANCE', FND_NUMBER.CANONICAL_TO_NUMBER(ORG_LINK_INFORMATION2), NULL)), (DECODE (ORG_LINK_INFORMATION_CATEGORY, 'DE_SOCIAL_INSURANCE', ORG_LINK_INFORMATION2, 'DE_LIABILITY_INSURANCE', ORG_LINK_INFORMATION3, NULL)), ORG_LINK_INFORMATION1, ORG_LINK_INFORMATION3,
(DECODE (ORG_LINK_INFORMATION_CATEGORY,
'DE_LIABILITY_INSURANCE', ORG_LINK_INFORMATION_CATEGORY || '.' || ORG_LINK_INFORMATION1 || '.' || ORG_LINK_INFORMATION2 || '.' || ORG_LINK_INFORMATION3,
'DE_SOCIAL_INSURANCE', ORG_LINK_INFORMATION_CATEGORY || '.' || ORG_LINK_INFORMATION1 || '.' || ORG_LINK_INFORMATION2 || '.' || ORG_LINK_INFORMATION3, NULL))
FROM HR_DE_ORGANIZATION_LINKS
SELECT ROWID
, ORG_LINK_INFORMATION_CATEGORY
, ORG_LINK_INFORMATION1
, (DECODE (ORG_LINK_INFORMATION_CATEGORY
, 'DE_LIABILITY_INSURANCE'
, FND_NUMBER.CANONICAL_TO_NUMBER(ORG_LINK_INFORMATION2)
, NULL))
, (DECODE (ORG_LINK_INFORMATION_CATEGORY
, 'DE_SOCIAL_INSURANCE'
, ORG_LINK_INFORMATION2
, 'DE_LIABILITY_INSURANCE'
, ORG_LINK_INFORMATION3
, NULL))
, ORG_LINK_INFORMATION1
, ORG_LINK_INFORMATION3
,
(DECODE (ORG_LINK_INFORMATION_CATEGORY
,
'DE_LIABILITY_INSURANCE'
, ORG_LINK_INFORMATION_CATEGORY || '.' || ORG_LINK_INFORMATION1 || '.' || ORG_LINK_INFORMATION2 || '.' || ORG_LINK_INFORMATION3
,
'DE_SOCIAL_INSURANCE'
, ORG_LINK_INFORMATION_CATEGORY || '.' || ORG_LINK_INFORMATION1 || '.' || ORG_LINK_INFORMATION2 || '.' || ORG_LINK_INFORMATION3
, NULL))
FROM HR_DE_ORGANIZATION_LINKS
|
|
|