The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
supplied_resource_id,
vendor_id,
business_group_id,
resource_definition_id,
consumable_flag,
object_version_number,
resource_type,
start_date,
comments,
cost,
cost_unit,
currency_code,
end_date,
internal_address_line,
lead_time,
name,
supplier_reference,
tsr_information_category,
tsr_information1,
tsr_information2,
tsr_information3,
tsr_information4,
tsr_information5,
tsr_information6,
tsr_information7,
tsr_information8,
tsr_information9,
tsr_information10,
tsr_information11,
tsr_information12,
tsr_information13,
tsr_information14,
tsr_information15,
tsr_information16,
tsr_information17,
tsr_information18,
tsr_information19,
tsr_information20,
training_center_id ,
location_id ,
trainer_id ,
special_instruction
from ota_suppliable_resources
where supplied_resource_id = p_supplied_resource_id;
select supplied_resource_id,
vendor_id,
business_group_id,
resource_definition_id,
consumable_flag,
object_version_number,
resource_type,
start_date,
comments,
cost,
cost_unit,
currency_code,
end_date,
internal_address_line,
lead_time,
name,
supplier_reference,
tsr_information_category,
tsr_information1,
tsr_information2,
tsr_information3,
tsr_information4,
tsr_information5,
tsr_information6,
tsr_information7,
tsr_information8,
tsr_information9,
tsr_information10,
tsr_information11,
tsr_information12,
tsr_information13,
tsr_information14,
tsr_information15,
tsr_information16,
tsr_information17,
tsr_information18,
tsr_information19,
tsr_information20,
training_center_id,
location_id,
trainer_id,
special_instruction
from ota_suppliable_resources
where supplied_resource_id = p_supplied_resource_id
for update nowait;