Oracle EBS AR 收款调整取值

SELECT ct.trx_number,adj.adjustment_number,ad.amount_dr,ad.amount_cr,ad.source_table,ad.source_type,xla_oa_functions_pkg.get_ccid_description(gcc.chart_of_accounts_id,ad.code_combination_id)
  FROM ar_distributions_all ad,ar_adjustments_all   adj,ra_customer_trx_all  ct,gl_code_combinations         gcc
 WHERE ad.source_table = ‘ADJ‘
   AND ad.source_id = adj.adjustment_id
   AND adj.customer_trx_id = ct.customer_trx_id
   AND gcc.code_combination_id = ad.code_combination_id;

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!