View: OTFV_TRAINING_ACTIVITIES

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

View Text

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, TAV.VERSION_NAME ACTIVITY_NAME
, TAV.COMMENTS ACTIVITY_COMMENTS
, TAV.START_DATE ACTIVITY_START_DATE
, TAV.END_DATE ACTIVITY_END_DATE
, TAV.DESCRIPTION DESCRIPTION
, DECODE(TAV.USER_STATUS
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('ACTIVITY_USER_STATUS'
, TAV.USER_STATUS)) STATUS
, TAV.OBJECTIVES OBJECTIVES
, TAV.INTENDED_AUDIENCE TARGET_AUDIENCE
, TAV.SUCCESS_CRITERIA SUCCESS_CRITERIA
, DECODE(TAV.EXPENSES_ALLOWED
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, TAV.EXPENSES_ALLOWED)) EXPENSES_ALLOWED
, TAV.PROFESSIONAL_CREDITS PROFESSIONAL_CREDITS
, TAV.PROFESSIONAL_CREDIT_TYPE PROFESSIONAL_CREDITS_TYPE
, TAD.NAME ACTIVITY_TYPE
, LNG.DESCRIPTION LANGUAGE
, PEO.FULL_NAME MANAGED_BY
, VEN.VENDOR_NAME SUPPLIER_NAME
, '_DF:OTA:OTA_ACTIVITY_DEFINITIONS:TAD'
, '_DF:OTA:OTA_ACTIVITY_VERSIONS:TAV'
, TAV.ACTIVITY_ID ACTIVITY_ID
, TAV.ACTIVITY_VERSION_ID ACTIVITY_VERSION_ID
, TAD.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, TAV.CONTROLLING_PERSON_ID CONTROLLING_PERSON_ID
, TAV.RCO_ID RCO_ID
FROM FND_LANGUAGES_VL LNG
, PO_VENDORS VEN
, PER_ALL_PEOPLE_F PEO
, HR_ALL_ORGANIZATION_UNITS BGR
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, OTA_ACTIVITY_DEFINITIONS TAD
, OTA_ACTIVITY_VERSIONS TAV
WHERE TAV.LANGUAGE_ID = LNG.LANGUAGE_ID(+)
AND TAV.ACTIVITY_ID = TAD.ACTIVITY_ID
AND TAV.CONTROLLING_PERSON_ID = PEO.PERSON_ID(+)
AND TAV.START_DATE BETWEEN PEO.EFFECTIVE_START_DATE(+)
AND PEO.EFFECTIVE_END_DATE(+)
AND TAV.VENDOR_ID = VEN.VENDOR_ID(+)
AND TAD.BUSINESS_GROUP_ID = BGR.ORGANIZATION_ID
AND BGR.ORGANIZATION_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND TAD.BUSINESS_GROUP_ID = NVL(OTA_GENERAL.GET_BUSINESS_GROUP_ID
, TAD.BUSINESS_GROUP_ID) WITH READ ONLY

Columns