VIEW: APPS.OTFV_EVENTS_WITHOUT_TRAINER

Source

View Text - Preformatted

SELECT ett.title event_title ,evt.event_id event_id ,evt.parent_offering_id offering_id FROM ota_events evt ,ota_events_tl ett WHERE evt.event_id NOT IN ( SELECT evt1.event_id FROM ota_events evt1 , ota_suppliable_resources tsr , ota_resource_bookings trb WHERE evt1.event_id = trb.event_id AND trb.supplied_resource_id = tsr.supplied_resource_id AND tsr.resource_type = 'T' AND trb.status = 'C' ) AND evt.event_type NOT IN ('PROGRAMME','AD HOC') AND evt.event_id = ett.event_id AND ett.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 ETT.TITLE EVENT_TITLE
, EVT.EVENT_ID EVENT_ID
, EVT.PARENT_OFFERING_ID OFFERING_ID
FROM OTA_EVENTS EVT
, OTA_EVENTS_TL ETT
WHERE EVT.EVENT_ID NOT IN ( SELECT EVT1.EVENT_ID
FROM OTA_EVENTS EVT1
, OTA_SUPPLIABLE_RESOURCES TSR
, OTA_RESOURCE_BOOKINGS TRB
WHERE EVT1.EVENT_ID = TRB.EVENT_ID
AND TRB.SUPPLIED_RESOURCE_ID = TSR.SUPPLIED_RESOURCE_ID
AND TSR.RESOURCE_TYPE = 'T'
AND TRB.STATUS = 'C' )
AND EVT.EVENT_TYPE NOT IN ('PROGRAMME'
, 'AD HOC')
AND EVT.EVENT_ID = ETT.EVENT_ID
AND ETT.LANGUAGE = USERENV('LANG')
AND EVT.BUSINESS_GROUP_ID = NVL(OTA_GENERAL.GET_BUSINESS_GROUP_ID
, EVT.BUSINESS_GROUP_ID) WITH READ ONLY