View: OTFV_EVENTS_WITH_VENUE

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

View Text

SELECT EVT.TITLE EVENT_TITLE
, TSR.NAME VENUE_NAME
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, TRB.PRIMARY_VENUE_FLAG) PRIMARY_VENUE
, TRB.DATE_BOOKING_PLACED DATE_BOOKING_PLACED
, HR_BIS.BIS_DECODE_LOOKUP('RESOURCE_BOOKING_STATUS'
, TRB.STATUS) BOOKING_STATUS
, TRB.REQUIRED_DATE_FROM REQUIRED_FROM
, TRB.REQUIRED_DATE_TO REQUIRED_TO
, TRB.RESOURCE_BOOKING_ID RESOURCE_BOOKING_ID
, TSR.SUPPLIED_RESOURCE_ID SUPPLIED_RESOURCE_ID
, EVT.EVENT_ID EVENT_ID
, EVT.OFFERING_ID OFFERING_ID
FROM OTA_EVENTS EVT
, OTA_RESOURCE_BOOKINGS TRB
, OTA_SUPPLIABLE_RESOURCES TSR
WHERE EVT.EVENT_ID = TRB.EVENT_ID AND TSR.SUPPLIED_RESOURCE_ID = TRB.SUPPLIED_RESOURCE_ID
AND TSR.RESOURCE_TYPE = 'V' AND EVT.BUSINESS_GROUP_ID = NVL(OTA_GENERAL.GET_BUSINESS_GROUP_ID
, EVT.BUSINESS_GROUP_ID) WITH READ ONLY

Columns