VIEW: APPS.OTA_SKILLS_V

Source

View Text - Preformatted

SELECT SIT.ROWID , SIT.BUSINESS_GROUP_ID , SIT.SPECIAL_INFORMATION_TYPE_ID , SIT.ID_FLEX_NUM , IFS.ID_FLEX_STRUCTURE_NAME FROM PER_SPECIAL_INFO_TYPES SIT, FND_ID_FLEX_STRUCTURES_VL IFS WHERE SIT.ID_FLEX_NUM = IFS.ID_FLEX_NUM AND IFS.ID_FLEX_CODE = 'PEA' AND EXISTS (SELECT NULL FROM PER_SPECIAL_INFO_TYPE_USAGES ITU WHERE ITU.SPECIAL_INFORMATION_TYPE_ID = SIT.SPECIAL_INFORMATION_TYPE_ID AND ITU.SPECIAL_INFO_CATEGORY = 'SKILL')

View Text - HTML Formatted

SELECT SIT.ROWID
, SIT.BUSINESS_GROUP_ID
, SIT.SPECIAL_INFORMATION_TYPE_ID
, SIT.ID_FLEX_NUM
, IFS.ID_FLEX_STRUCTURE_NAME
FROM PER_SPECIAL_INFO_TYPES SIT
, FND_ID_FLEX_STRUCTURES_VL IFS
WHERE SIT.ID_FLEX_NUM = IFS.ID_FLEX_NUM
AND IFS.ID_FLEX_CODE = 'PEA'
AND EXISTS (SELECT NULL
FROM PER_SPECIAL_INFO_TYPE_USAGES ITU
WHERE ITU.SPECIAL_INFORMATION_TYPE_ID = SIT.SPECIAL_INFORMATION_TYPE_ID
AND ITU.SPECIAL_INFO_CATEGORY = 'SKILL')