[Home] [Help]
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
Name |
EVENT_TITLE |
TRAINER_NAME |
TRAINER_ROLE |
DATE_OF_BOOKING |
BOOKING_STATUS |
REQUIRED_FROM |
REQUIRED_TO |
RESOURCE_BOOKING_ID |
SUPPLIED_RESOURCE_ID |
EVENT_ID |
OFFERING_ID |