View: OTFV_EVENTS_WITHOUT_VENUE

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

View Text

SELECT EVT.TITLE EVENT_TITLE
, EVT.EVENT_ID EVENT_ID
, EVT.OFFERING_ID OFFERING_ID
FROM OTA_EVENTS EVT
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.BUSINESS_GROUP_ID = NVL(OTA_GENERAL.GET_BUSINESS_GROUP_ID
, EVT.BUSINESS_GROUP_ID) WITH READ ONLY

Columns