[Home] [Help]
SELECT ett.title event_title ,tst.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.comments booking_comments ,trb.resource_booking_id resource_booking_id ,trb.supplied_resource_id supplied_resource_id ,evt.event_id event_id ,evt.parent_offering_id offering_id FROM ota_events evt ,ota_events_tl ett ,ota_suppliable_resources tsr ,ota_suppliable_resources_tl tst ,ota_resource_bookings trb WHERE evt.event_id = trb.event_id AND evt.event_id = ett.event_id AND ett.language = userenv('LANG') AND tsr.supplied_resource_id = trb.supplied_resource_id AND tsr.supplied_resource_id = tst.supplied_resource_id AND tst.language = userenv('LANG') AND tsr.resource_type = 'T' AND evt.business_group_id = NVL(ota_general.get_business_group_id,evt.business_group_id) WITH READ ONLY
SELECT ETT.TITLE EVENT_TITLE
, TST.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.COMMENTS BOOKING_COMMENTS
, TRB.RESOURCE_BOOKING_ID RESOURCE_BOOKING_ID
, TRB.SUPPLIED_RESOURCE_ID SUPPLIED_RESOURCE_ID
, EVT.EVENT_ID EVENT_ID
, EVT.PARENT_OFFERING_ID OFFERING_ID
FROM OTA_EVENTS EVT
, OTA_EVENTS_TL ETT
, OTA_SUPPLIABLE_RESOURCES TSR
, OTA_SUPPLIABLE_RESOURCES_TL TST
, OTA_RESOURCE_BOOKINGS TRB
WHERE EVT.EVENT_ID = TRB.EVENT_ID
AND EVT.EVENT_ID = ETT.EVENT_ID
AND ETT.LANGUAGE = USERENV('LANG')
AND TSR.SUPPLIED_RESOURCE_ID = TRB.SUPPLIED_RESOURCE_ID
AND TSR.SUPPLIED_RESOURCE_ID = TST.SUPPLIED_RESOURCE_ID
AND TST.LANGUAGE = USERENV('LANG')
AND TSR.RESOURCE_TYPE = 'T'
AND EVT.BUSINESS_GROUP_ID = NVL(OTA_GENERAL.GET_BUSINESS_GROUP_ID
, EVT.BUSINESS_GROUP_ID) WITH READ ONLY
|
|
|
|