APPS.AR_BUS_EVENT_SUB_PVT dependencies on AR_CASH_RECEIPTS

Line 718: ar_cash_receipts cr

714: cr.receipt_date as_of_date,
715: sum(nvl(ra.amount_applied_from,ra.amount_applied)) receipt_amount
716: from ar_receivable_applications ra,
717: ar_payment_schedules rps,
718: ar_cash_receipts cr
719: where ra.request_id = p_req_id
720: and ra.status = 'UNAPP'
721: and sign(ra.amount_applied) = 1
722: and rps.payment_schedule_id = ra.payment_schedule_id

Line 753: from ar_cash_receipts cr,

749: nvl(cr.customer_site_use_id,-99) customer_site_use_id,
750: cr.currency_code currency,
751: cr.org_id,
752: max(cr.receipt_date) last_cash_receipt_date
753: from ar_cash_receipts cr,
754: ar_receivable_applications ra
755: where ra.request_id = p_req_id
756: and ra.status = 'UNAPP'
757: and sign(ra.amount_applied) = 1

Line 763: ar_cash_receipts b

759: group by cr.pay_from_customer,
760: nvl(cr.customer_site_use_id,-99),
761: cr.currency_code,
762: cr.org_id) a,
763: ar_cash_receipts b
764: where a.last_cash_receipt_date = b.receipt_date
765: and a.customer_id = b.pay_from_customer
766: and a.customer_site_use_id = nvl(b.customer_site_use_id,-99)
767: and a.org_id = b.org_id

Line 772: ar_cash_receipts cr1

768: and a.currency = b.currency_code
769: group by a.customer_id,
770: a.customer_site_use_id,
771: a.currency) c,
772: ar_cash_receipts cr1
773: WHERE cr1.cash_receipt_id = c.cash_receipt_id;
774:
775: cursor application_info(p_req_id IN NUMBER) IS
776: select ps.customer_id trx_customer_id,

Line 3881: ar_cash_receipts cr,

3877: 'ACC', nvl(ra.amount_applied_from,ra.amount_applied),
3878: 'OTHER ACC',nvl(ra.amount_applied_from,ra.amount_applied),
3879: null)) unresolved_cash
3880: FROM ar_payment_schedules ps,
3881: ar_cash_receipts cr,
3882: ar_cash_receipt_history crh,
3883: ar_receivable_applications ra
3884: WHERE ps.payment_schedule_id = p_ps_id
3885: and ps.cash_receipt_id = cr.cash_receipt_id

Line 3916: from ar_cash_receipts

3912: CURSOR get_last_pmt (p_customer_id IN NUMBER,
3913: p_site_use_id IN NUMBER,
3914: p_currency IN VARCHAR2) IS
3915: select receipt_number, amount, receipt_date
3916: from ar_cash_receipts
3917: where cash_receipt_id =
3918: (select max(cr.cash_receipt_id)
3919: from ar_cash_receipts cr,
3920: ar_cash_receipt_history crh --apandit

Line 3919: from ar_cash_receipts cr,

3915: select receipt_number, amount, receipt_date
3916: from ar_cash_receipts
3917: where cash_receipt_id =
3918: (select max(cr.cash_receipt_id)
3919: from ar_cash_receipts cr,
3920: ar_cash_receipt_history crh --apandit
3921: where cr.pay_from_customer = p_customer_id
3922: and cr.cash_receipt_id = crh.cash_receipt_id --apandit
3923: and crh.current_record_flag = 'Y'

Line 4811: FROM ar_cash_receipts

4807: CURSOR get_last_pmt (p_customer_id IN NUMBER,
4808: p_site_use_id IN NUMBER,
4809: p_currency IN VARCHAR2) IS
4810: SELECT receipt_number, amount, receipt_date
4811: FROM ar_cash_receipts
4812: WHERE cash_receipt_id =
4813: (SELECT MAX(cr.cash_receipt_id)
4814: FROM ar_cash_receipts cr,
4815: ar_cash_receipt_history crh

Line 4814: FROM ar_cash_receipts cr,

4810: SELECT receipt_number, amount, receipt_date
4811: FROM ar_cash_receipts
4812: WHERE cash_receipt_id =
4813: (SELECT MAX(cr.cash_receipt_id)
4814: FROM ar_cash_receipts cr,
4815: ar_cash_receipt_history crh
4816: WHERE cr.pay_from_customer = p_customer_id
4817: AND cr.cash_receipt_id = crh.cash_receipt_id
4818: AND crh.current_record_flag = 'Y'