[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
finance_line_id,
finance_header_id,
cancelled_flag,
date_raised,
line_type,
object_version_number,
sequence_number,
transfer_status,
comments,
currency_code,
money_amount,
standard_amount,
trans_information_category,
trans_information1,
trans_information10,
trans_information11,
trans_information12,
trans_information13,
trans_information14,
trans_information15,
trans_information16,
trans_information17,
trans_information18,
trans_information19,
trans_information2,
trans_information20,
trans_information3,
trans_information4,
trans_information5,
trans_information6,
trans_information7,
trans_information8,
trans_information9,
transfer_date,
transfer_message,
unitary_amount,
booking_deal_id,
booking_id,
resource_allocation_id,
resource_booking_id,
tfl_information_category,
tfl_information1,
tfl_information2,
tfl_information3,
tfl_information4,
tfl_information5,
tfl_information6,
tfl_information7,
tfl_information8,
tfl_information9,
tfl_information10,
tfl_information11,
tfl_information12,
tfl_information13,
tfl_information14,
tfl_information15,
tfl_information16,
tfl_information17,
tfl_information18,
tfl_information19,
tfl_information20
from ota_finance_lines
where finance_line_id = p_finance_line_id;
select finance_line_id,
finance_header_id,
cancelled_flag,
date_raised,
line_type,
object_version_number,
sequence_number,
transfer_status,
comments,
currency_code,
money_amount,
standard_amount,
trans_information_category,
trans_information1,
trans_information10,
trans_information11,
trans_information12,
trans_information13,
trans_information14,
trans_information15,
trans_information16,
trans_information17,
trans_information18,
trans_information19,
trans_information2,
trans_information20,
trans_information3,
trans_information4,
trans_information5,
trans_information6,
trans_information7,
trans_information8,
trans_information9,
transfer_date,
transfer_message,
unitary_amount,
booking_deal_id,
booking_id,
resource_allocation_id,
resource_booking_id,
tfl_information_category,
tfl_information1,
tfl_information2,
tfl_information3,
tfl_information4,
tfl_information5,
tfl_information6,
tfl_information7,
tfl_information8,
tfl_information9,
tfl_information10,
tfl_information11,
tfl_information12,
tfl_information13,
tfl_information14,
tfl_information15,
tfl_information16,
tfl_information17,
tfl_information18,
tfl_information19,
tfl_information20
from ota_finance_lines
where finance_line_id = p_finance_line_id
for update nowait;