导出AR退款明细的SQL

纵横四海

执行以前需要初始化

begin
  fnd_client_info.set_org_context(85);
end;
select tt.customer_id,
       tt.customer_name,
       tt.customer_number,
       tt.gl_date as shoukuan_date,
       t.GL_DATE as tuikuan_date,
       t.AMOUNT_APPLIED,
       t.TRX_NUMBER,
       tt.receipt_number
  from AR_RECEIVABLE_APPLICATIONS_V t, AR_CASH_RECEIPTS_V tt
where t.TRX_NUMBER = 'Receipt Write-off'
   and t.CASH_RECEIPT_ID = tt.cash_receipt_id
   and t.GL_DATE > to_date('20050101', 'YYYYMMDD')
   and t.GL_DATE < to_date('20050331', 'YYYYMMDD')
;

bowenbaba

有点不明白退款的TRX_NUMBER,就是'Receipt Write-off'?

newone

没做过退款呢

newone

学习学习！请赐教！谢谢！