[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select booking_id,
booking_status_type_id,
delegate_person_id,
contact_id,
business_group_id,
event_id,
customer_id,
authorizer_person_id,
date_booking_placed,
corespondent,
internal_booking_flag,
number_of_places,
object_version_number,
administrator,
booking_priority,
comments,
contact_address_id,
delegate_contact_phone,
delegate_contact_fax,
third_party_customer_id,
third_party_contact_id,
third_party_address_id,
third_party_contact_phone,
third_party_contact_fax,
date_status_changed,
failure_reason,
attendance_result,
language_id,
source_of_booking,
special_booking_instructions,
successful_attendance_flag,
tdb_information_category,
tdb_information1,
tdb_information2,
tdb_information3,
tdb_information4,
tdb_information5,
tdb_information6,
tdb_information7,
tdb_information8,
tdb_information9,
tdb_information10,
tdb_information11,
tdb_information12,
tdb_information13,
tdb_information14,
tdb_information15,
tdb_information16,
tdb_information17,
tdb_information18,
tdb_information19,
tdb_information20,
organization_id,
sponsor_person_id,
sponsor_assignment_id,
person_address_id,
delegate_assignment_id,
delegate_contact_id,
delegate_contact_email,
third_party_email,
person_address_type,
line_id,
org_id,
daemon_flag,
daemon_type,
old_event_id,
quote_line_id,
interface_source,
total_training_time,
content_player_status,
score,
completed_content,
total_content ,
booking_justification_id,
is_history_flag,
is_mandatory_enrollment
from ota_delegate_bookings
where booking_id = p_booking_id;
select booking_id,
booking_status_type_id,
delegate_person_id,
contact_id,
business_group_id,
event_id,
customer_id,
authorizer_person_id,
date_booking_placed,
corespondent,
internal_booking_flag,
number_of_places,
object_version_number,
administrator,
booking_priority,
comments,
contact_address_id,
delegate_contact_phone,
delegate_contact_fax,
third_party_customer_id,
third_party_contact_id,
third_party_address_id,
third_party_contact_phone,
third_party_contact_fax,
date_status_changed,
failure_reason,
attendance_result,
language_id,
source_of_booking,
special_booking_instructions,
successful_attendance_flag,
tdb_information_category,
tdb_information1,
tdb_information2,
tdb_information3,
tdb_information4,
tdb_information5,
tdb_information6,
tdb_information7,
tdb_information8,
tdb_information9,
tdb_information10,
tdb_information11,
tdb_information12,
tdb_information13,
tdb_information14,
tdb_information15,
tdb_information16,
tdb_information17,
tdb_information18,
tdb_information19,
tdb_information20,
organization_id,
sponsor_person_id,
sponsor_assignment_id,
person_address_id,
delegate_assignment_id,
delegate_contact_id,
delegate_contact_email,
third_party_email,
person_address_type,
created_by,
line_id,
org_id,
daemon_flag,
daemon_type,
old_event_id,
quote_line_id,
interface_source,
total_training_time,
content_player_status,
score,
completed_content,
total_content,
booking_justification_id,
is_history_flag,
is_mandatory_enrollment
from ota_delegate_bookings
where booking_id = p_booking_id
for update nowait;