APPS.AR_CUMULATIVE_BALANCE_REPORT dependencies on AR_CASH_RECEIPTS_ALL

Line 29: IS TABLE OF ar_cash_receipts_all.receipt_number%TYPE

25: IS TABLE OF ar_receipt_methods.name%TYPE
26: INDEX BY BINARY_INTEGER;
27:
28: TYPE trx_number_type
29: IS TABLE OF ar_cash_receipts_all.receipt_number%TYPE
30: INDEX BY BINARY_INTEGER;
31:
32: TYPE trx_date_type
33: IS TABLE OF ra_customer_trx_all.trx_date%TYPE

Line 111: g_ar_cash_receipts_all VARCHAR2(40) DEFAULT NULL;

107: g_ar_adjustments_all VARCHAR2(40) DEFAULT NULL;
108: g_ar_cash_receipt_history VARCHAR2(40) DEFAULT NULL;
109: g_ar_cash_receipt_history_all VARCHAR2(40) DEFAULT NULL;
110: g_ar_cash_receipts VARCHAR2(40) DEFAULT NULL;
111: g_ar_cash_receipts_all VARCHAR2(40) DEFAULT NULL;
112: g_ar_distributions VARCHAR2(40) DEFAULT NULL;
113: g_ar_distributions_all VARCHAR2(40) DEFAULT NULL;
114: g_ra_customer_trx VARCHAR2(40) DEFAULT NULL;
115: g_ra_customer_trx_all VARCHAR2(40) DEFAULT NULL;

Line 296: FROM ' || g_ar_cash_receipts_all || ', '

292: 'UPDATE ar_base_gl_acct_balances bal
293: SET (trx_number, trx_type, trx_date, currency) =
294: (
295: SELECT receipt_number, rm.name, receipt_date, currency_code
296: FROM ' || g_ar_cash_receipts_all || ', '
297: || g_ar_receipt_methods || '
298: WHERE cr.receipt_method_id = rm.receipt_method_id
299: AND cr.cash_receipt_id = bal.cash_receipt_id
300: AND rownum = 1

Line 317: FROM ' || g_ar_cash_receipts_all || ', '

313: 'UPDATE ar_gl_acct_balances bal
314: SET (trx_number, trx_type, trx_date, currency) =
315: (
316: SELECT receipt_number, rm.name, receipt_date, currency_code
317: FROM ' || g_ar_cash_receipts_all || ', '
318: || g_ar_receipt_methods || '
319: WHERE cr.receipt_method_id = rm.receipt_method_id
320: AND cr.cash_receipt_id = bal.cash_receipt_id
321: AND rownum = 1

Line 583: g_ar_cash_receipts_all || ', ' ||

579: max(ard.org_id) org_id
580: FROM ' ||
581: g_ar_distributions_all || ', ' ||
582: g_ar_cash_receipt_history_all || ', ' ||
583: g_ar_cash_receipts_all || ', ' ||
584: g_ar_receipt_methods || ' , ' ||
585: 'ar_ccid_by_gl_accounts glc
586: WHERE crh.gl_date between :p_start_date and :p_end_date
587: AND crh.cash_receipt_history_id = ard.source_id

Line 686: g_ar_cash_receipts_all || ', ' ||

682: max(ard.org_id) org_id
683: FROM ' ||
684: g_ar_distributions_all || ', ' ||
685: g_ar_misc_cash_dists_all || ', ' ||
686: g_ar_cash_receipts_all || ', ' ||
687: g_ar_receipt_methods || ', ' ||
688: ' ar_ccid_by_gl_accounts glc
689: WHERE mcd.gl_date between :p_start_date and :p_end_date
690: AND mcd.misc_cash_distribution_id = ard.source_id

Line 1530: g_ar_cash_receipts_all := 'ar_cash_receipts_all cr';

1526: g_ar_adjustments_all := 'ar_adjustments_all adj';
1527: g_ar_cash_receipt_history := 'ar_cash_receipt_history crh';
1528: g_ar_cash_receipt_history_all := 'ar_cash_receipt_history_all crh';
1529: g_ar_cash_receipts := 'ar_cash_receipts cr';
1530: g_ar_cash_receipts_all := 'ar_cash_receipts_all cr';
1531: --{Replaced
1532: -- g_ar_distributions := 'ar_distributions ard';
1533: g_ar_distributions := 'ar_xla_ard_lines_v ard';
1534: -- g_ar_distributions_all := 'ar_distributions_all ard';

Line 1564: g_ar_cash_receipts_all := 'ar_cash_receipts_all_mrc_v cr';

1560: g_ar_adjustments_all := 'ar_adjustments_all_mrc_v adj';
1561: g_ar_cash_receipt_history := 'ar_cash_receipt_hist_mrc_v crh';
1562: g_ar_cash_receipt_history_all := 'ar_cash_receipt_hist_all_mrc_v crh';
1563: g_ar_cash_receipts := 'ar_cash_receipts cr';
1564: g_ar_cash_receipts_all := 'ar_cash_receipts_all_mrc_v cr';
1565: g_ar_distributions := 'ar_distributions_mrc_v ard';
1566: g_ar_distributions_all := 'ar_distributions_all_mrc_v ard';
1567: g_ra_customer_trx := 'ra_customer_trx_mrc_v trx';
1568: g_ra_customer_trx_all := 'ra_customer_trx_all_mrc_v trx';