DBA Data[Home] [Help]

APPS.ARP_CUSTOMER_AGING dependencies on AR_CASH_RECEIPT_HISTORY

Line 3250: ar_cash_receipt_history crh

3246: -- bug 1865105 starts
3247: SELECT NVL( SUM( DECODE(p_currency_code, NULL, crh.acctd_amount,
3248: crh.amount)), 0)
3249: FROM ar_cash_receipts cr,
3250: ar_cash_receipt_history crh
3251: WHERE cr.pay_from_customer = p_customer_id
3252: /* bug no : 1274152. Aging form did not consider the receipts done without custo
3253: mer location for the calculation of receipt at risk. NVL is added for ps.custome
3254: r_site_use_id in the procedure calc_risk_receipts to avoid null = null compariso