VIEW: APPS.OTFV_SKILL_PROVISIONS

Source

View Text - Preformatted

SELECT hr_bis.bis_decode_lookup('SKILL_PROVISION_TYPE',tsp.type) skill_provision_type ,tsp.comments skill_provision_comments ,'_KF:PER:PEA:anc' ,tvt.version_name activity_name ,tdt.name activity_type ,'_DF:OTA:OTA_SKILL_PROVISIONS:tsp' ,tsp.analysis_criteria_id analysis_criteria_id ,tav.activity_version_id activity_version_id ,tad.activity_id activity_id ,tsp.skill_provision_id skill_provision_id ,tav.rco_id rco_id FROM ota_skill_provisions tsp ,ota_activity_definitions tad ,ota_activity_definitions_tl tdt ,ota_activity_versions tav ,ota_activity_versions_tl tvt ,per_analysis_criteria anc WHERE tsp.activity_version_id = tav.activity_version_id AND tav.activity_version_id = tvt.activity_version_id AND tvt.language = userenv('LANG') AND anc.analysis_criteria_id = tsp.analysis_criteria_id AND tav.activity_id = tad.activity_id AND tad.activity_id = tdt.activity_id AND tdt.language = userenv('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT HR_BIS.BIS_DECODE_LOOKUP('SKILL_PROVISION_TYPE'
, TSP.TYPE) SKILL_PROVISION_TYPE
, TSP.COMMENTS SKILL_PROVISION_COMMENTS
, '_KF:PER:PEA:ANC'
, TVT.VERSION_NAME ACTIVITY_NAME
, TDT.NAME ACTIVITY_TYPE
, '_DF:OTA:OTA_SKILL_PROVISIONS:TSP'
, TSP.ANALYSIS_CRITERIA_ID ANALYSIS_CRITERIA_ID
, TAV.ACTIVITY_VERSION_ID ACTIVITY_VERSION_ID
, TAD.ACTIVITY_ID ACTIVITY_ID
, TSP.SKILL_PROVISION_ID SKILL_PROVISION_ID
, TAV.RCO_ID RCO_ID
FROM OTA_SKILL_PROVISIONS TSP
, OTA_ACTIVITY_DEFINITIONS TAD
, OTA_ACTIVITY_DEFINITIONS_TL TDT
, OTA_ACTIVITY_VERSIONS TAV
, OTA_ACTIVITY_VERSIONS_TL TVT
, PER_ANALYSIS_CRITERIA ANC
WHERE TSP.ACTIVITY_VERSION_ID = TAV.ACTIVITY_VERSION_ID
AND TAV.ACTIVITY_VERSION_ID = TVT.ACTIVITY_VERSION_ID
AND TVT.LANGUAGE = USERENV('LANG')
AND ANC.ANALYSIS_CRITERIA_ID = TSP.ANALYSIS_CRITERIA_ID
AND TAV.ACTIVITY_ID = TAD.ACTIVITY_ID
AND TAD.ACTIVITY_ID = TDT.ACTIVITY_ID
AND TDT.LANGUAGE = USERENV('LANG') WITH READ ONLY