DBA Data[Home] [Help]

APPS.PQP_PVD_SHD SQL Statements

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

Line: 59

    select
       vehicle_details_id
      ,vehicle_type
      ,business_group_id
      ,registration_number
      ,make
      ,model
      ,date_first_registered
      ,engine_capacity_in_cc
      ,fuel_type
      ,fuel_card
      ,currency_code
      ,list_price
      ,accessory_value_at_startdate
      ,accessory_value_added_later
--      ,capital_contributions
--      ,private_use_contributions
      ,market_value_classic_car
      ,co2_emissions
      ,vehicle_provider
      ,object_version_number
      ,vehicle_identification_number
      ,vehicle_ownership
      ,vhd_attribute_category
      ,vhd_attribute1
      ,vhd_attribute2
      ,vhd_attribute3
      ,vhd_attribute4
      ,vhd_attribute5
      ,vhd_attribute6
      ,vhd_attribute7
      ,vhd_attribute8
      ,vhd_attribute9
      ,vhd_attribute10
      ,vhd_attribute11
      ,vhd_attribute12
      ,vhd_attribute13
      ,vhd_attribute14
      ,vhd_attribute15
      ,vhd_attribute16
      ,vhd_attribute17
      ,vhd_attribute18
      ,vhd_attribute19
      ,vhd_attribute20
      ,vhd_information_category
      ,vhd_information1
      ,vhd_information2
      ,vhd_information3
      ,vhd_information4
      ,vhd_information5
      ,vhd_information6
      ,vhd_information7
      ,vhd_information8
      ,vhd_information9
      ,vhd_information10
      ,vhd_information11
      ,vhd_information12
      ,vhd_information13
      ,vhd_information14
      ,vhd_information15
      ,vhd_information16
      ,vhd_information17
      ,vhd_information18
      ,vhd_information19
      ,vhd_information20
    from	pqp_vehicle_details
    where	vehicle_details_id = p_vehicle_details_id;
Line: 188

    select
       vehicle_details_id
      ,vehicle_type
      ,business_group_id
      ,registration_number
      ,make
      ,model
      ,date_first_registered
      ,engine_capacity_in_cc
      ,fuel_type
      ,fuel_card
      ,currency_code
      ,list_price
      ,accessory_value_at_startdate
      ,accessory_value_added_later
--      ,capital_contributions
--      ,private_use_contributions
      ,market_value_classic_car
      ,co2_emissions
      ,vehicle_provider
      ,object_version_number
      ,vehicle_identification_number
      ,vehicle_ownership
      ,vhd_attribute_category
      ,vhd_attribute1
      ,vhd_attribute2
      ,vhd_attribute3
      ,vhd_attribute4
      ,vhd_attribute5
      ,vhd_attribute6
      ,vhd_attribute7
      ,vhd_attribute8
      ,vhd_attribute9
      ,vhd_attribute10
      ,vhd_attribute11
      ,vhd_attribute12
      ,vhd_attribute13
      ,vhd_attribute14
      ,vhd_attribute15
      ,vhd_attribute16
      ,vhd_attribute17
      ,vhd_attribute18
      ,vhd_attribute19
      ,vhd_attribute20
      ,vhd_information_category
      ,vhd_information1
      ,vhd_information2
      ,vhd_information3
      ,vhd_information4
      ,vhd_information5
      ,vhd_information6
      ,vhd_information7
      ,vhd_information8
      ,vhd_information9
      ,vhd_information10
      ,vhd_information11
      ,vhd_information12
      ,vhd_information13
      ,vhd_information14
      ,vhd_information15
      ,vhd_information16
      ,vhd_information17
      ,vhd_information18
      ,vhd_information19
      ,vhd_information20
    from	pqp_vehicle_details
    where	vehicle_details_id = p_vehicle_details_id
    for	update nowait;