APPS.AR_CUMULATIVE_BALANCE_REPORT dependencies on RA_CUSTOMER_TRX_ALL

Line 33: IS TABLE OF ra_customer_trx_all.trx_date%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
34: INDEX BY BINARY_INTEGER;
35:
36: TYPE currency_code_type
37: IS TABLE OF ra_customer_trx_all.invoice_currency_code%TYPE

Line 37: IS TABLE OF ra_customer_trx_all.invoice_currency_code%TYPE

33: IS TABLE OF ra_customer_trx_all.trx_date%TYPE
34: INDEX BY BINARY_INTEGER;
35:
36: TYPE currency_code_type
37: IS TABLE OF ra_customer_trx_all.invoice_currency_code%TYPE
38: INDEX BY BINARY_INTEGER;
39:
40: TYPE gl_date_type
41: IS TABLE OF --{Replace ra_cust_trx_line_gl_dist_all.gl_date%TYPE by

Line 115: g_ra_customer_trx_all 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;
116: g_ra_cust_trx_gl_dist VARCHAR2(40) DEFAULT NULL;
117: g_ra_cust_trx_gl_dist_all VARCHAR2(40) DEFAULT NULL;
118: g_ar_misc_cash_dists VARCHAR2(40) DEFAULT NULL;
119: g_ar_misc_cash_dists_all VARCHAR2(40) DEFAULT NULL;

Line 340: FROM ' || g_ra_customer_trx_all || ', '

336: 'UPDATE ar_base_gl_acct_balances bal
337: SET (trx_number, trx_type, trx_date, currency) =
338: (
339: SELECT trx_number, ctt.name, trx_date, invoice_currency_code
340: FROM ' || g_ra_customer_trx_all || ', '
341: || g_ra_cust_trx_types_all || '
342: WHERE trx.cust_trx_type_id = ctt.cust_trx_type_id
343: AND trx.customer_trx_id = bal.customer_trx_id
344: AND rownum = 1

Line 362: FROM ' || g_ra_customer_trx_all || ', '

358: 'UPDATE ar_gl_acct_balances bal
359: SET (trx_number, trx_type, trx_date, currency) =
360: (
361: SELECT trx_number, ctt.name, trx_date, invoice_currency_code
362: FROM ' || g_ra_customer_trx_all || ', '
363: || g_ra_cust_trx_types_all || '
364: WHERE trx.cust_trx_type_id = ctt.cust_trx_type_id
365: AND trx.customer_trx_id = bal.customer_trx_id
366: AND rownum = 1

Line 537: g_ra_customer_trx_all || ', ' ||

533: null adjustment_id,
534: max(dist.org_id) org_id
535: FROM ' ||
536: g_ra_cust_trx_gl_dist_all || ', ' ||
537: g_ra_customer_trx_all || ', ' ||
538: g_ra_cust_trx_types_all ||
539: ', ar_ccid_by_gl_accounts glc
540: WHERE dist.gl_date BETWEEN :p_start_date AND :p_end_date
541: AND dist.account_set_flag = ''N''

Line 739: g_ra_customer_trx_all || ', ' ||

735: max(ard.org_id) org_id
736: FROM ' ||
737: g_ar_distributions_all || ', ' ||
738: g_ar_adjustments_all || ', ' ||
739: g_ra_customer_trx_all || ', ' ||
740: g_ra_cust_trx_types_all || ', ' ||
741: ' ar_ccid_by_gl_accounts glc
742: WHERE adj.gl_date between :p_start_date and :p_end_date
743: AND adj.adjustment_id = ard.source_id

Line 1538: g_ra_customer_trx_all := 'ra_customer_trx_all trx';

1534: -- g_ar_distributions_all := 'ar_distributions_all ard';
1535: g_ar_distributions_all := 'ar_xla_ard_lines_v ard';
1536: --}
1537: g_ra_customer_trx := 'ra_customer_trx trx';
1538: g_ra_customer_trx_all := 'ra_customer_trx_all trx';
1539: --{Replaced
1540: -- g_ra_cust_trx_gl_dist := 'ra_cust_trx_line_gl_dist dist';
1541: g_ra_cust_trx_gl_dist := 'ar_xla_ctlgd_lines_v dist';
1542: -- g_ra_cust_trx_gl_dist_all := 'ra_cust_trx_line_gl_dist_all dist';

Line 1568: g_ra_customer_trx_all := 'ra_customer_trx_all_mrc_v trx';

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';
1569: g_ra_cust_trx_gl_dist := 'ra_trx_line_gl_dist_all_mrc_v dist';
1570: g_ra_cust_trx_gl_dist_all := 'ra_trx_line_gl_dist_mrc_v dist';
1571: g_ar_misc_cash_dists := 'ar_misc_cash_dists_mrc_v mcd';
1572: g_ar_misc_cash_dists_all := 'ar_misc_cash_dists_all_mrc_v mcd';