随笔分类 -  Oracle EBS-SQL (GL)

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_recover... 阅读全文

posted @ 2014-06-09 16:17 st.sun

Oracle EBS-SQL (GL-4):从接收追溯到接收事务
摘要:SELECT row_id, creation_date, created_by, last_update_date, last_updated_by,last_update_login, note_to_receiver, pll_note_to_receiver,rma_reference, t... 阅读全文

posted @ 2014-06-09 16:16 st.sun

Oracle EBS-SQL (GL-3):从总帐追溯到发票
摘要: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_... 阅读全文

posted @ 2014-06-09 16:15 st.sun

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_lin... 阅读全文

posted @ 2014-06-09 16:14 st.sun

Oracle EBS-SQL (GL-1):从总帐追溯到接收
摘要: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_... 阅读全文

posted @ 2014-06-09 16:12 st.sun

导航