VIEW: APPS.OTA_SKILL_PROVISIONS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'