APPS.OTA_TSR_SHD SQL Statements

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

Line: 159

    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;

Line: 271

    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;