[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
finance_header_id,
superceding_header_id,
authorizer_person_id,
organization_id,
administrator,
cancelled_flag,
currency_code,
date_raised,
object_version_number,
payment_status_flag,
transfer_status,
type,
receivable_type,
comments,
external_reference,
invoice_address,
invoice_contact,
payment_method,
pym_attribute1,
pym_attribute10,
pym_attribute11,
pym_attribute12,
pym_attribute13,
pym_attribute14,
pym_attribute15,
pym_attribute16,
pym_attribute17,
pym_attribute18,
pym_attribute19,
pym_attribute2,
pym_attribute20,
pym_attribute3,
pym_attribute4,
pym_attribute5,
pym_attribute6,
pym_attribute7,
pym_attribute8,
pym_attribute9,
pym_information_category,
transfer_date,
transfer_message,
vendor_id,
contact_id,
address_id,
customer_id,
tfh_information_category,
tfh_information1,
tfh_information2,
tfh_information3,
tfh_information4,
tfh_information5,
tfh_information6,
tfh_information7,
tfh_information8,
tfh_information9,
tfh_information10,
tfh_information11,
tfh_information12,
tfh_information13,
tfh_information14,
tfh_information15,
tfh_information16,
tfh_information17,
tfh_information18,
tfh_information19,
tfh_information20,
paying_cost_center,
receiving_cost_center,
transfer_from_set_of_books_id,
transfer_to_set_of_books_id,
from_segment1,
from_segment2,
from_segment3,
from_segment4,
from_segment5,
from_segment6,
from_segment7,
from_segment8,
from_segment9,
from_segment10,
from_segment11,
from_segment12,
from_segment13,
from_segment14,
from_segment15,
from_segment16,
from_segment17,
from_segment18,
from_segment19,
from_segment20,
from_segment21,
from_segment22,
from_segment23,
from_segment24,
from_segment25,
from_segment26,
from_segment27,
from_segment28,
from_segment29,
from_segment30,
to_segment1,
to_segment2,
to_segment3,
to_segment4,
to_segment5,
to_segment6,
to_segment7,
to_segment8,
to_segment9,
to_segment10,
to_segment11,
to_segment12,
to_segment13,
to_segment14,
to_segment15,
to_segment16,
to_segment17,
to_segment18,
to_segment19,
to_segment20,
to_segment21,
to_segment22,
to_segment23,
to_segment24,
to_segment25,
to_segment26,
to_segment27,
to_segment28,
to_segment29,
to_segment30,
transfer_from_cc_id,
transfer_to_cc_id
from ota_finance_headers
where finance_header_id = p_finance_header_id;
select finance_header_id,
superceding_header_id,
authorizer_person_id,
organization_id,
administrator,
cancelled_flag,
currency_code,
date_raised,
object_version_number,
payment_status_flag,
transfer_status,
type,
receivable_type,
comments,
external_reference,
invoice_address,
invoice_contact,
payment_method,
pym_attribute1,
pym_attribute10,
pym_attribute11,
pym_attribute12,
pym_attribute13,
pym_attribute14,
pym_attribute15,
pym_attribute16,
pym_attribute17,
pym_attribute18,
pym_attribute19,
pym_attribute2,
pym_attribute20,
pym_attribute3,
pym_attribute4,
pym_attribute5,
pym_attribute6,
pym_attribute7,
pym_attribute8,
pym_attribute9,
pym_information_category,
transfer_date,
transfer_message,
vendor_id,
contact_id,
address_id,
customer_id,
tfh_information_category,
tfh_information1,
tfh_information2,
tfh_information3,
tfh_information4,
tfh_information5,
tfh_information6,
tfh_information7,
tfh_information8,
tfh_information9,
tfh_information10,
tfh_information11,
tfh_information12,
tfh_information13,
tfh_information14,
tfh_information15,
tfh_information16,
tfh_information17,
tfh_information18,
tfh_information19,
tfh_information20,
paying_cost_center,
receiving_cost_center,
transfer_from_set_of_books_id,
transfer_to_set_of_books_id,
from_segment1,
from_segment2,
from_segment3,
from_segment4,
from_segment5,
from_segment6,
from_segment7,
from_segment8,
from_segment9,
from_segment10,
from_segment11,
from_segment12,
from_segment13,
from_segment14,
from_segment15,
from_segment16,
from_segment17,
from_segment18,
from_segment19,
from_segment20,
from_segment21,
from_segment22,
from_segment23,
from_segment24,
from_segment25,
from_segment26,
from_segment27,
from_segment28,
from_segment29,
from_segment30,
to_segment1,
to_segment2,
to_segment3,
to_segment4,
to_segment5,
to_segment6,
to_segment7,
to_segment8,
to_segment9,
to_segment10,
to_segment11,
to_segment12,
to_segment13,
to_segment14,
to_segment15,
to_segment16,
to_segment17,
to_segment18,
to_segment19,
to_segment20,
to_segment21,
to_segment22,
to_segment23,
to_segment24,
to_segment25,
to_segment26,
to_segment27,
to_segment28,
to_segment29,
to_segment30,
transfer_from_cc_id,
transfer_to_cc_id
from ota_finance_headers
where finance_header_id = p_finance_header_id
for update nowait;