APPS.OTA_RUD_SHD SQL Statements

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

Line: 99

    select
       resource_usage_id
      ,supplied_resource_id
      ,activity_version_id
      ,object_version_number
      ,required_flag
      ,start_date
      ,comments
      ,end_date
      ,quantity
      ,resource_type
      ,role_to_play
      ,usage_reason
      ,rud_information_category
      ,rud_information1
      ,rud_information2
      ,rud_information3
      ,rud_information4
      ,rud_information5
      ,rud_information6
      ,rud_information7
      ,rud_information8
      ,rud_information9
      ,rud_information10
      ,rud_information11
      ,rud_information12
      ,rud_information13
      ,rud_information14
      ,rud_information15
      ,rud_information16
      ,rud_information17
      ,rud_information18
      ,rud_information19
      ,rud_information20
      ,offering_id
    from        ota_resource_usages
    where       resource_usage_id = p_resource_usage_id;

Line: 198

    select 	resource_usage_id,
	supplied_resource_id,
	activity_version_id,
	object_version_number,
	required_flag,
	start_date,
	comments,
	end_date,
	quantity,
	resource_type,
	role_to_play,
	usage_reason,
	rud_information_category,
	rud_information1,
	rud_information2,
	rud_information3,
	rud_information4,
	rud_information5,
	rud_information6,
	rud_information7,
	rud_information8,
	rud_information9,
	rud_information10,
	rud_information11,
	rud_information12,
	rud_information13,
	rud_information14,
	rud_information15,
	rud_information16,
	rud_information17,
	rud_information18,
	rud_information19,
	rud_information20,
    offering_id
    from	ota_resource_usages
    where	resource_usage_id = p_resource_usage_id
    for	update nowait;