[Home] [Help]
3889: 'OTHER ACC',nvl(ra.amount_applied_from,ra.amount_applied),
3890: null)) unresolved_cash
3891: FROM ar_payment_schedules ps,
3892: ar_cash_receipts cr,
3893: ar_cash_receipt_history crh,
3894: ar_receivable_applications ra
3895: WHERE ps.payment_schedule_id = p_ps_id
3896: and ps.cash_receipt_id = cr.cash_receipt_id
3897: and crh.cash_receipt_id = cr.cash_receipt_id
3927: from ar_cash_receipts
3928: where cash_receipt_id =
3929: (select max(cr.cash_receipt_id)
3930: from ar_cash_receipts cr,
3931: ar_cash_receipt_history crh --apandit
3932: where cr.pay_from_customer = p_customer_id
3933: and cr.cash_receipt_id = crh.cash_receipt_id --apandit
3934: and crh.current_record_flag = 'Y'
3935: and crh.status <> 'REVERSED'
4822: FROM ar_cash_receipts
4823: WHERE cash_receipt_id =
4824: (SELECT MAX(cr.cash_receipt_id)
4825: FROM ar_cash_receipts cr,
4826: ar_cash_receipt_history crh
4827: WHERE cr.pay_from_customer = p_customer_id
4828: AND cr.cash_receipt_id = crh.cash_receipt_id
4829: AND crh.current_record_flag = 'Y'
4830: AND crh.status <> 'REVERSED'
7241: SET receipts_at_risk_value =
7242: (SELECT SUM(DECODE(rap.applied_payment_schedule_id, -2, 0,
7243: crh.amount))
7244: FROM ar_cash_receipts_all cr,
7245: ar_cash_receipt_history_all crh,
7246: ar_receivable_applications_all rap
7247: WHERE nvl(cr.confirmed_flag, 'Y') = 'Y'
7248: AND cr.reversal_date IS NULL
7249: AND cr.cash_receipt_id = crh.cash_receipt_id
7283: SET receipts_at_risk_value = receipts_at_risk_value -
7284: (SELECT SUM(DECODE(rap.applied_payment_schedule_id, -2, 0,
7285: crh.amount))
7286: FROM ar_cash_receipts_all cr,
7287: ar_cash_receipt_history_all crh,
7288: ar_receivable_applications_all rap
7289: WHERE nvl(cr.confirmed_flag, 'Y') = 'Y'
7290: AND cr.reversal_date IS NULL
7291: AND cr.cash_receipt_id = crh.cash_receipt_id