Product: | OTA - Learning Management |
---|---|
Description: | View to list all skills which are provided by an activity. |
Implementation/DBA Data: | APPS.OTA_SKILL_PROVISIONS_V |
SELECT TSP.ROWID
, TSP.SKILL_PROVISION_ID
, TSP.ACTIVITY_VERSION_ID
, AVT.VERSION_NAME
, TAV.START_DATE
, TAV.END_DATE
, TAD.ACTIVITY_ID
, ADT.NAME
, TAD.BUSINESS_GROUP_ID
, SIT.SPECIAL_INFORMATION_TYPE_ID
, SIT.ID_FLEX_NUM
, IFS.ID_FLEX_STRUCTURE_NAME
, TSP.OBJECT_VERSION_NUMBER
, TSP.TYPE
, HRL.MEANING
, TSP.COMMENTS
, TSP.LAST_UPDATE_DATE
, TSP.LAST_UPDATED_BY
, TSP.LAST_UPDATE_LOGIN
, TSP.CREATED_BY
, TSP.CREATION_DATE
, TSP.TSP_INFORMATION_CATEGORY
, TSP.TSP_INFORMATION1
, TSP.TSP_INFORMATION2
, TSP.TSP_INFORMATION3
, TSP.TSP_INFORMATION4
, TSP.TSP_INFORMATION5
, TSP.TSP_INFORMATION6
, TSP.TSP_INFORMATION7
, TSP.TSP_INFORMATION8
, TSP.TSP_INFORMATION9
, TSP.TSP_INFORMATION10
, TSP.TSP_INFORMATION11
, TSP.TSP_INFORMATION12
, TSP.TSP_INFORMATION13
, TSP.TSP_INFORMATION14
, TSP.TSP_INFORMATION15
, TSP.TSP_INFORMATION16
, TSP.TSP_INFORMATION17
, TSP.TSP_INFORMATION18
, TSP.TSP_INFORMATION19
, TSP.TSP_INFORMATION20
, TSP.ANALYSIS_CRITERIA_ID
FROM OTA_SKILL_PROVISIONS TSP
, OTA_ACTIVITY_DEFINITIONS TAD
, OTA_ACTIVITY_DEFINITIONS_TL ADT
, OTA_ACTIVITY_VERSIONS TAV
, OTA_ACTIVITY_VERSIONS_TL AVT
, PER_SPECIAL_INFO_TYPES SIT
, FND_ID_FLEX_STRUCTURES_VL IFS
, PER_ANALYSIS_CRITERIA PAC
, HR_LOOKUPS HRL
WHERE TAV.ACTIVITY_VERSION_ID = TSP.ACTIVITY_VERSION_ID
AND AVT.ACTIVITY_VERSION_ID = TAV.ACTIVITY_VERSION_ID
AND AVT.LANGUAGE= USERENV('LANG')
AND TAD.ACTIVITY_ID = TAV.ACTIVITY_ID
AND ADT.ACTIVITY_ID = TAD.ACTIVITY_ID
AND ADT.LANGUAGE = USERENV('LANG')
AND IFS.ID_FLEX_NUM = SIT.ID_FLEX_NUM
AND IFS.ID_FLEX_CODE= 'PEA'
AND IFS.APPLICATION_ID = 800
AND SIT.BUSINESS_GROUP_ID = TAD.BUSINESS_GROUP_ID
AND SIT.ID_FLEX_NUM = PAC.ID_FLEX_NUM
AND TSP.ANALYSIS_CRITERIA_ID = PAC.ANALYSIS_CRITERIA_ID
AND HRL.LOOKUP_CODE = TSP.TYPE
AND HRL.LOOKUP_TYPE = 'SKILL_PROVISION_TYPE'