View: OTFV_SKILL_PROVISIONS

Product:	OTA - Learning Management
Description:	Business view template from which the flexfield view is generated.
Implementation/DBA Data:	APPS.OTFV_SKILL_PROVISIONS

View Text

SELECT HR_BIS.BIS_DECODE_LOOKUP('SKILL_PROVISION_TYPE'
, TSP.TYPE) SKILL_PROVISION_TYPE
, TSP.COMMENTS SKILL_PROVISION_COMMENTS
, '_KF:PER:PEA:ANC'
, TAV.VERSION_NAME ACTIVITY_NAME
, TAD.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_VERSIONS TAV
, PER_ANALYSIS_CRITERIA ANC
WHERE TSP.ACTIVITY_VERSION_ID = TAV.ACTIVITY_VERSION_ID
AND ANC.ANALYSIS_CRITERIA_ID = TSP.ANALYSIS_CRITERIA_ID
AND TAV.ACTIVITY_ID = TAD.ACTIVITY_ID WITH READ ONLY

Columns