APPS.OTA_TRB_SHD SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 180

    select
		resource_booking_id,
	supplied_resource_id,
	event_id,
	date_booking_placed,
	object_version_number,
	status,
	absolute_price,
	booking_person_id,
	comments,
	contact_name,
	contact_phone_number,
	delegates_per_unit,
	quantity,
	required_date_from,
	required_date_to,
	required_end_time,
	required_start_time,
	deliver_to,
	primary_venue_flag,
	role_to_play,
	trb_information_category,
	trb_information1,
	trb_information2,
	trb_information3,
	trb_information4,
	trb_information5,
	trb_information6,
	trb_information7,
	trb_information8,
	trb_information9,
	trb_information10,
	trb_information11,
	trb_information12,
	trb_information13,
	trb_information14,
	trb_information15,
	trb_information16,
	trb_information17,
	trb_information18,
	trb_information19,
	trb_information20
	,display_to_learner_flag
   ,book_entire_period_flag
 --   ,unbook_request_flag
      ,chat_id
      ,forum_id
      ,timezone_code
    from	ota_resource_bookings
    where	resource_booking_id = p_resource_booking_id;

Line: 297

    select 	resource_booking_id,
	supplied_resource_id,
	event_id,
	date_booking_placed,
	object_version_number,
	status,
	absolute_price,
	booking_person_id,
	comments,
	contact_name,
	contact_phone_number,
	delegates_per_unit,
	quantity,
	required_date_from,
	required_date_to,
	required_end_time,
	required_start_time,
	deliver_to,
	primary_venue_flag,
	role_to_play,
	trb_information_category,
	trb_information1,
	trb_information2,
	trb_information3,
	trb_information4,
	trb_information5,
	trb_information6,
	trb_information7,
	trb_information8,
	trb_information9,
	trb_information10,
	trb_information11,
	trb_information12,
	trb_information13,
	trb_information14,
	trb_information15,
	trb_information16,
	trb_information17,
	trb_information18,
	trb_information19,
	trb_information20
	,display_to_learner_flag
   ,book_entire_period_flag
  --  ,unbook_request_flag
      ,chat_id
      ,forum_id
      ,timezone_code
    from	ota_resource_bookings
    where	resource_booking_id = p_resource_booking_id
    for	update nowait;