DBA Data[Home] [Help]

APPS.ARP_ARXVASUM dependencies on AR_CASH_RECEIPT_HISTORY

Line 410: ar_cash_receipt_history crh

406: p_sum_risk_func_rem_amt,
407: p_risk_count
408: from ar_cash_receipts cr,
409: ar_payment_schedules ps,
410: ar_cash_receipt_history crh
411: where ps.customer_id = p_customer_id /* Bug 1963032 */
412: and ps.cash_receipt_id = cr.cash_receipt_id
413: and nvl(ps.customer_site_use_id, -10) = nvl(p_site_use_id, nvl(ps.customer_site_use_id, -10) )
414: and ps.gl_date between p_start_date and p_end_date

Line 780: ar_cash_receipt_history crh

776: p_pend_confirm_func_amt,
777: p_pend_confirm_count
778: from ar_payment_schedules ps,
779: ar_cash_receipts cr,
780: ar_cash_receipt_history crh
781: where ps.customer_id = p_customer_id /* bug1963032 */
782: and ps.cash_receipt_id = cr.cash_receipt_id
783: and nvl(ps.customer_site_use_id, -10) = nvl(p_site_use_id, nvl(ps.customer_site_use_id,
784: -10) )

Line 886: ar_cash_receipt_history crh,

882: l_func_rem_amt,
883: l_count
884: from ar_cash_receipts cr,
885: ar_payment_schedules ps,
886: ar_cash_receipt_history crh,
887: ar_receipt_methods rm,
888: ar_receipt_classes rc
889: where ps.customer_id = p_customer_id /* bug1963032 */
890: and ps.cash_receipt_id = cr.cash_receipt_id

Line 1031: ar_cash_receipt_history crh

1027: l_func_rem_amt,
1028: l_count
1029: from ar_cash_receipts cr,
1030: ar_payment_schedules ps,
1031: ar_cash_receipt_history crh
1032: where ps.customer_id = p_customer_id /* bug1963032 */
1033: and ps.cash_receipt_id = cr.cash_receipt_id
1034: and nvl(ps.customer_site_use_id, -10) = nvl(p_site_use_id, nvl(ps.customer_site_use_id, -10) )
1035: and ps.gl_date between p_start_date and p_end_date