View: OTFV_EVENTS_WITH_TRAINER

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

View Text

SELECT EVT.TITLE EVENT_TITLE
, TSR.NAME TRAINER_NAME
, TRB.ROLE_TO_PLAY TRAINER_ROLE
, TRB.DATE_BOOKING_PLACED DATE_OF_BOOKING
, 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
, TRB.SUPPLIED_RESOURCE_ID SUPPLIED_RESOURCE_ID
, EVT.EVENT_ID EVENT_ID
, EVT.OFFERING_ID OFFERING_ID
FROM OTA_EVENTS EVT
, OTA_SUPPLIABLE_RESOURCES TSR
, OTA_RESOURCE_BOOKINGS TRB
WHERE EVT.EVENT_ID = TRB.EVENT_ID
AND TSR.SUPPLIED_RESOURCE_ID = TRB.SUPPLIED_RESOURCE_ID AND TSR.RESOURCE_TYPE = 'T' AND EVT.BUSINESS_GROUP_ID = NVL(OTA_GENERAL.GET_BUSINESS_GROUP_ID
, EVT.BUSINESS_GROUP_ID) WITH READ ONLY

Columns