VIEW: APPS.OTFV_EVENTS_WITHOUT_VENUE

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 tsr1 , ota_resource_bookings trb1 WHERE evt1.event_id = trb1.event_id AND trb1.supplied_resource_id = tsr1.supplied_resource_id AND tsr1.resource_type = 'V' AND trb1.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 TSR1
, OTA_RESOURCE_BOOKINGS TRB1
WHERE EVT1.EVENT_ID = TRB1.EVENT_ID
AND TRB1.SUPPLIED_RESOURCE_ID = TSR1.SUPPLIED_RESOURCE_ID
AND TSR1.RESOURCE_TYPE = 'V'
AND TRB1.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