View: OTFV_EVENTS_WITHOUT_TRAINER

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

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 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.BUSINESS_GROUP_ID = NVL(OTA_GENERAL.GET_BUSINESS_GROUP_ID
, EVT.BUSINESS_GROUP_ID) WITH READ ONLY

Columns