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 314: FROM ' || g_ra_customer_trx_all || ', '

310: 'UPDATE ar_base_gl_acct_balances bal
311: SET (trx_number, trx_type, trx_date, currency) =
312: (
313: SELECT trx_number, ctt.name, trx_date, invoice_currency_code
314: FROM ' || g_ra_customer_trx_all || ', '
315: || g_ra_cust_trx_types_all || '
316: WHERE trx.cust_trx_type_id = ctt.cust_trx_type_id
317: AND trx.customer_trx_id = bal.customer_trx_id
318: AND rownum = 1

Line 336: FROM ' || g_ra_customer_trx_all || ', '

332: 'UPDATE ar_gl_acct_balances bal
333: SET (trx_number, trx_type, trx_date, currency) =
334: (
335: SELECT trx_number, ctt.name, trx_date, invoice_currency_code
336: FROM ' || g_ra_customer_trx_all || ', '
337: || g_ra_cust_trx_types_all || '
338: WHERE trx.cust_trx_type_id = ctt.cust_trx_type_id
339: AND trx.customer_trx_id = bal.customer_trx_id
340: AND rownum = 1

Line 511: g_ra_customer_trx_all || ', ' ||

507: null adjustment_id,
508: max(dist.org_id) org_id
509: FROM ' ||
510: g_ra_cust_trx_gl_dist_all || ', ' ||
511: g_ra_customer_trx_all || ', ' ||
512: g_ra_cust_trx_types_all ||
513: ', ar_ccid_by_gl_accounts glc
514: WHERE dist.gl_date BETWEEN :p_start_date AND :p_end_date
515: AND dist.account_set_flag = ''N''

Line 713: g_ra_customer_trx_all || ', ' ||

709: max(ard.org_id) org_id
710: FROM ' ||
711: g_ar_distributions_all || ', ' ||
712: g_ar_adjustments_all || ', ' ||
713: g_ra_customer_trx_all || ', ' ||
714: g_ra_cust_trx_types_all || ', ' ||
715: ' ar_ccid_by_gl_accounts glc
716: WHERE adj.gl_date between :p_start_date and :p_end_date
717: AND adj.adjustment_id = ard.source_id

Line 1509: g_ra_customer_trx_all := 'ra_customer_trx_all trx';

1505: -- g_ar_distributions_all := 'ar_distributions_all ard';
1506: g_ar_distributions_all := 'ar_xla_ard_lines_v ard';
1507: --}
1508: g_ra_customer_trx := 'ra_customer_trx trx';
1509: g_ra_customer_trx_all := 'ra_customer_trx_all trx';
1510: --{Replaced
1511: -- g_ra_cust_trx_gl_dist := 'ra_cust_trx_line_gl_dist dist';
1512: g_ra_cust_trx_gl_dist := 'ar_xla_ctlgd_lines_v dist';
1513: -- g_ra_cust_trx_gl_dist_all := 'ra_cust_trx_line_gl_dist_all dist';

Line 1539: g_ra_customer_trx_all := 'ra_customer_trx_all_mrc_v trx';

1535: g_ar_cash_receipts_all := 'ar_cash_receipts_all_mrc_v cr';
1536: g_ar_distributions := 'ar_distributions_mrc_v ard';
1537: g_ar_distributions_all := 'ar_distributions_all_mrc_v ard';
1538: g_ra_customer_trx := 'ra_customer_trx_mrc_v trx';
1539: g_ra_customer_trx_all := 'ra_customer_trx_all_mrc_v trx';
1540: g_ra_cust_trx_gl_dist := 'ra_trx_line_gl_dist_all_mrc_v dist';
1541: g_ra_cust_trx_gl_dist_all := 'ra_trx_line_gl_dist_mrc_v dist';
1542: g_ar_misc_cash_dists := 'ar_misc_cash_dists_mrc_v mcd';
1543: g_ar_misc_cash_dists_all := 'ar_misc_cash_dists_all_mrc_v mcd';