VIEW: APPS.OTFV_ONE_TIME_TRAINING_EVENTS

Source

View Text - Preformatted

SELECT bgrT.name business_group_name ,ett.title event_name ,evt.comments event_comments ,evt.course_start_date event_start_date ,evt.course_end_date event_end_date ,evt.course_start_time event_start_time ,evt.course_end_time event_end_time ,evt.timezone ,evt.duration duration ,DECODE(evt.duration_units,NULL,NULL, hr_bis.bis_decode_lookup('OTA_DURATION_UNITS',evt.duration_units)) duration_units ,orgT1.name training_centre ,ven.vendor_name supplier_name ,'_DF:OTA:OTA_EVENTS:evt' ,evt.business_group_id business_group_id ,evt.event_id event_id ,evt.training_center_id training_center_id ,evt.parent_offering_id offering_id FROM po_vendors ven ,hr_all_organization_units bgr ,hr_all_organization_units_tl bgrT ,ota_events evt ,ota_events_tl ett ,hr_all_organization_units_tl orgT1 WHERE evt.vendor_id = ven.vendor_id(+) AND evt.event_id = ett.event_id AND ett.language = userenv('LANG') AND evt.training_center_id = orgT1.organization_id(+) AND DECODE(orgT1.language,NULL,'X',orgT1.language)= DECODE(orgT1.language,NULL,'X',userenv('LANG')) AND evt.event_type = 'AD HOC' AND evt.business_group_id = bgr.organization_id AND bgr.organization_id = bgrT.organization_id AND bgrT.language = userenv('LANG') AND evt.business_group_id = NVL(ota_general.get_business_group_id,evt.business_group_id) WITH READ ONLY

View Text - HTML Formatted

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, ETT.TITLE EVENT_NAME
, EVT.COMMENTS EVENT_COMMENTS
, EVT.COURSE_START_DATE EVENT_START_DATE
, EVT.COURSE_END_DATE EVENT_END_DATE
, EVT.COURSE_START_TIME EVENT_START_TIME
, EVT.COURSE_END_TIME EVENT_END_TIME
, EVT.TIMEZONE
, EVT.DURATION DURATION
, DECODE(EVT.DURATION_UNITS
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('OTA_DURATION_UNITS'
, EVT.DURATION_UNITS)) DURATION_UNITS
, ORGT1.NAME TRAINING_CENTRE
, VEN.VENDOR_NAME SUPPLIER_NAME
, '_DF:OTA:OTA_EVENTS:EVT'
, EVT.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, EVT.EVENT_ID EVENT_ID
, EVT.TRAINING_CENTER_ID TRAINING_CENTER_ID
, EVT.PARENT_OFFERING_ID OFFERING_ID
FROM PO_VENDORS VEN
, HR_ALL_ORGANIZATION_UNITS BGR
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, OTA_EVENTS EVT
, OTA_EVENTS_TL ETT
, HR_ALL_ORGANIZATION_UNITS_TL ORGT1
WHERE EVT.VENDOR_ID = VEN.VENDOR_ID(+)
AND EVT.EVENT_ID = ETT.EVENT_ID
AND ETT.LANGUAGE = USERENV('LANG')
AND EVT.TRAINING_CENTER_ID = ORGT1.ORGANIZATION_ID(+)
AND DECODE(ORGT1.LANGUAGE
, NULL
, 'X'
, ORGT1.LANGUAGE)= DECODE(ORGT1.LANGUAGE
, NULL
, 'X'
, USERENV('LANG'))
AND EVT.EVENT_TYPE = 'AD HOC'
AND EVT.BUSINESS_GROUP_ID = BGR.ORGANIZATION_ID
AND BGR.ORGANIZATION_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND EVT.BUSINESS_GROUP_ID = NVL(OTA_GENERAL.GET_BUSINESS_GROUP_ID
, EVT.BUSINESS_GROUP_ID) WITH READ ONLY