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