VIEW: APPS.OTFV_TRAINING_ACTIVITIES

Source

View Text - Preformatted

SELECT bgrT.name business_group_name ,tvt.version_name activity_name ,tav.comments activity_comments ,tav.start_date activity_start_date ,tav.end_date activity_end_date ,tvt.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 ,tdt.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_definitions_tl tdt ,ota_activity_versions tav ,ota_activity_versions_tl tvt WHERE tav.language_id = lng.language_id(+) AND tav.activity_version_id = tvt.activity_version_id AND tvt.language = userenv('LANG') AND tav.activity_id = tad.activity_id AND tad.activity_id = tdt.activity_id AND tdt.language = userenv('LANG') 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

View Text - HTML Formatted

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, TVT.VERSION_NAME ACTIVITY_NAME
, TAV.COMMENTS ACTIVITY_COMMENTS
, TAV.START_DATE ACTIVITY_START_DATE
, TAV.END_DATE ACTIVITY_END_DATE
, TVT.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
, TDT.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_DEFINITIONS_TL TDT
, OTA_ACTIVITY_VERSIONS TAV
, OTA_ACTIVITY_VERSIONS_TL TVT
WHERE TAV.LANGUAGE_ID = LNG.LANGUAGE_ID(+)
AND TAV.ACTIVITY_VERSION_ID = TVT.ACTIVITY_VERSION_ID
AND TVT.LANGUAGE = USERENV('LANG')
AND TAV.ACTIVITY_ID = TAD.ACTIVITY_ID
AND TAD.ACTIVITY_ID = TDT.ACTIVITY_ID
AND TDT.LANGUAGE = USERENV('LANG')
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