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)

转载于:https://www.cnblogs.com/st-sun/p/3778122.html