摘要：
AR中发票资料中看科目组合信息：SELECT * FROM ar.ra_customer_trx_all rct, ar.ra_customer_trx_lines_all rctl, ar.ra_cust_trx_line_gl_dist_all rctgl, apps.gl_code_combinations gcc -- 账户组合 WHERE rct.customer_trx_id = rctl.customer_trx_id AND rctl.customer_trx_line_id ... 阅读全文
摘要：
select customer_name, customer_number, extended_amount, description, price, quantity, salename, startdate, enddate from (select hpt.party_name customer_name, hca.account_number customer_number, decode(ctl.gross_extended_amo... 阅读全文