Oracle EBS-SQL ，GL-5:从发票追溯到接收

SELECT destination_type_code, distribution_line_number, line_type, amount,

vat_code, tax_code_id, tax_code_override_flag, tax_recovery_rate,

tax_recoverable_flag, tax_recovery_override_flag, accounting_date,

amount_includes_tax_flag, assets_tracking_flag, description,

type_1099, income_tax_region, final_match_flag, quantity_invoiced,

unit_price, po_number, po_line_number, po_line_location_number,

po_distribution_number, receipt_number, project, task, award_id,

expenditure_type, expenditure_organization_name,

expenditure_item_date, pa_quantity, unit_of_measure,

prepay_distribution_id, prepay_number, prepay_dist_number,

prepay_amount_remaining, invoice_includes_prepay_flag, stat_amount,

awt_group_name, awt_creation_method, posted_status_disp,

start_expense_date, merchant_document_number, merchant_name,

merchant_tax_reg_number, merchant_taxpayer_id, merchant_reference,

country_of_supply, ussgl_transaction_code, last_update_date,

creation_date, row_id, accrual_posted_flag,

accts_pay_code_combination_id, assets_addition_flag,

invoice_distribution_id, attribute14, attribute1, attribute10,

attribute11, attribute12, attribute13, attribute15, attribute2,

attribute3, attribute4, attribute5, attribute6, attribute7,

attribute8, attribute9, attribute_category, awt_flag,

awt_gross_amount, awt_group_id, awt_invoice_id, awt_origin_group_id,

awt_tax_rate_id, base_amount, base_invoice_price_variance,

base_quantity_variance, batch_id, cash_je_batch_id, cash_posted_flag,

created_by, dist_code_combination_id, encumbered_flag, exchange_date,

exchange_rate, exchange_rate_type, exchange_rate_variance,

expenditure_organization_id, invoice_id, invoice_price_variance,

je_batch_id, last_updated_by, last_update_login,

line_type_lookup_code, match_status_flag, org_id, other_invoice_id,

packet_id, parent_invoice_id, pa_addition_flag, period_name,

posted_amount, posted_base_amount, posted_flag,

po_accrue_on_receipt_flag, po_code_combination_id,

po_distribution_id, price_var_code_combination_id,

program_application_id, program_id, program_update_date,

project_accounting_context, project_id, quantity_variance,

rate_var_code_combination_id, reference_1, reference_2, request_id,

reversal_flag, set_of_books_id, set_of_books_short_name, task_id,

tax_calculated_flag, ussgl_trx_code_context, invoice_num,

parent_invoice_num, batch_name, income_tax_region_name,

posted_status, je_batch_name, cash_je_batch_name,

chart_of_accounts_id, set_of_books_name, po_header_id, po_line_id,

line_location_id, rcv_transaction_id, unit_meas_lookup_code,

tax_type, matched_uom_lookup_code, parent_reversal_id,

global_attribute_category, global_attribute1, global_attribute2,

global_attribute3, global_attribute4, global_attribute5,

global_attribute6, global_attribute7, global_attribute8,

global_attribute9, global_attribute10, global_attribute11,

global_attribute12, global_attribute13, global_attribute14,

global_attribute15, global_attribute16, global_attribute17,

global_attribute18, global_attribute19, global_attribute20

FROM ap_invoice_distributions_v

WHERE invoice_id = 14653

ORDER BY distribution_line_number,

line_type,

amount,

DECODE (line_type_lookup_code, 'ITEM', 1, 'PREPAY', 3, 'AWT', 4, 2)