Oracle EBS-SQL (GL-2):从总帐追溯到库存

SELECT je_header_id,
je_line_num,trx_class_name, trx_type_name, trx_number_displayed, trx_date,

comments, doc_sequence_name, doc_sequence_value,acct_line_type_name,

currency_code, entered_dr, entered_cr, accounted_dr,accounted_cr,

taxable_entered_dr, taxable_entered_cr,taxable_accounted_dr,taxable_accounted_cr,

currency_conversion_date,currency_user_conversion_type, currency_conversion_rate,

third_party_name, third_party_number,third_party_sub_name,

accounting_date, gl_transfer_status_name,transfer_system_name,

gl_transfer_from_to_name, accounting_complete_name,

ae_line_reference, tax_code, accounting_rule_name,tax_exempt_number,

trx_line_type_name, trx_line_number,trx_detail_line_number,

trx_quantity, sales_order_number, salesrep_name, tax_rate,

unit_selling_price, trx_uom, trx_source_name,
asset_number,

asset_description, asset_book_type_code,
accounting_event_number,

accounting_event_type, accounting_event_type_name,

accounting_line_number, aeh_accounting_error_name,

ael_accounting_error_name, user_je_category_name,

transfer_status_detail_name, application_date,

applied_to_trx_hdr_currency, applied_to_trx_hdr_date,

applied_to_trx_hdr_id, applied_to_trx_hdr_number_c,

applied_to_trx_hdr_number_disp,
applied_to_trx_hdr_table,

applied_to_trx_line_number, applied_to_trx_line_type,

applied_to_trx_line_type_name, ar_activity_name,

ar_adjustment_creation_type, ar_adjustment_type,
bank_account_name,

bank_statement_doc_seq_id, bank_statement_doc_seq_name,

bank_statement_doc_seq_value, bank_statement_line_number,

bank_statement_number, bom_department_code,
bom_department_name,

chargeback_number, cost_element_id, cost_element_name,

distribution_set_name, gl_batch_id,
inventory_item_locator_id,

inventory_item_locator_name, inventory_item_revision,

item_description, inventory_organization_code,

inventory_organization_id, cost_type_id, cost_type_name,

mfg_operation_seq_num, payment_cleared_date,
payment_date,

payment_deposit_date, payment_number,
payment_recon_currency,

po_line_num, po_order_number, po_order_release_num,
price_override,

po_order_shipment_num, po_order_distribution_num,
po_order_type,

rcv_receipt_num, rcv_shipment_header_id,
reversal_comments,

reversal_date, subinventory, trx_hdr_currency,
trx_reason_name,

trx_source_type_id, trx_source_type_name, unit_cost,
unit_price,

wip_assembly, wip_basis, wip_flow_schedule_number,
wip_job_id,

wip_job_name, wip_line_code, wip_line_id,
wip_resource_id,

wip_resource_name, wip_resource_seq_num,
pa_employee_num,

pa_employee_name, pa_supplier_num, pa_supplier_name,
pa_project_num,

pa_project_name, pa_task_num, pa_task_name,
pa_ei_ev_org,

pa_nl_resource_org, pa_nl_resource, pa_ei_ev_type,
pa_event_num,

pa_quantity, pa_uom, pa_period_date,
pa_gl_transfer_date,

pa_customer_number, pa_customer_name, pa_agreement_num,

pa_accrue_thru_date, pa_dri_number, pa_trans_id,
pa_line_number,

prvdr_organization_name, recvr_organization_name,
prvdr_ou_name,

recvr_ou_name, cc_type_name, cc_proc_method_name,
application_id,

asset_id, asset_category_id,

asset_key_ccid, code_combination_id, inventory_item_id,

set_of_books_id, org_id, trx_class, trx_type_n,
trx_type_c,

trx_number_n, trx_number_c, doc_sequence_id,
trx_hdr_table,

trx_hdr_id, acct_line_type, currency_conversion_type,

third_party_type, third_party_id, third_party_sub_id,

gl_transfer_status, source_table, source_id, ael_table,
ael_id,

aeh_accounting_error_code, ael_accounting_error_code,
je_category,

trx_line_type, trx_source_id, last_update_date,
last_updated_by,

creation_date, created_by, last_update_login,
request_id,

program_application_id, program_id, program_update_date,

pa_project_id, pa_view_labor_cost

FROM xla_inv_ael_gl_v xla_ael_gl_v

WHERE je_header_id = 1573

AND je_line_num = 1205

ORDER BY trx_date,

trx_number_displayed,

acct_line_type_name,

cost_element_name

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