DBA Data[Home] [Help]

APPS.ARP_PROCESS_WRITEOFF dependencies on AR_PAYMENT_SCHEDULES

Line 330: FROM ar_payment_schedules ps,

326: SUM(DECODE(app.status,'ACTIVITY',DECODE(applied_payment_schedule_id,-3,
327: DECODE(app.created_by,c_user_id,
328: NVL(app.amount_applied_from,app.amount_applied),0),0),0)) written_off_amount,
329: crh.batch_id batch_id,acr.org_id
330: FROM ar_payment_schedules ps,
331: ar_cash_receipts acr,
332: ar_cash_receipt_history crh,
333: ar_receivable_applications app
334: WHERE ps.invoice_currency_code = c_receipt_currency_code