View: OTA_SKILLS_V

Product:	OTA - Learning Management
Description:	View to list all types of Skills.
Implementation/DBA Data:	APPS.OTA_SKILLS_V

View Text

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')

Columns