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

Oracle EBS-SQL (AR-2):检查应收收款核销额
摘要:SELECT cust.customer_number, cust.customer_name, cash.receipt_number, gcc.segment1 || '.' || gcc.segment2 || '.' || gcc.segment3 || '.' || gcc.segmen... 阅读全文

posted @ 2014-06-09 16:23 st.sun 编辑

Oracle EBS-SQL (AR-1):检查应收收款发生额
摘要:SELECT SUM(nvl(dist.amount_dr,0))-SUM(nvl(dist.amount_cr,0)) FROM ar_cash_receipt_history_all hist, ar_distributions_all distWHERE hist.cash_receipt_h... 阅读全文

posted @ 2014-06-09 16:21 st.sun 编辑

导航

点击右上角即可分享
微信分享提示