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 270: FROM ' || g_ar_cash_receipts_all || ', '

266: 'UPDATE ar_base_gl_acct_balances bal
267: SET (trx_number, trx_type, trx_date, currency) =
268: (
269: SELECT receipt_number, rm.name, receipt_date, currency_code
270: FROM ' || g_ar_cash_receipts_all || ', '
271: || g_ar_receipt_methods || '
272: WHERE cr.receipt_method_id = rm.receipt_method_id
273: AND cr.cash_receipt_id = bal.cash_receipt_id
274: AND rownum = 1

Line 291: FROM ' || g_ar_cash_receipts_all || ', '

287: 'UPDATE ar_gl_acct_balances bal
288: SET (trx_number, trx_type, trx_date, currency) =
289: (
290: SELECT receipt_number, rm.name, receipt_date, currency_code
291: FROM ' || g_ar_cash_receipts_all || ', '
292: || g_ar_receipt_methods || '
293: WHERE cr.receipt_method_id = rm.receipt_method_id
294: AND cr.cash_receipt_id = bal.cash_receipt_id
295: AND rownum = 1

Line 557: g_ar_cash_receipts_all || ', ' ||

553: max(ard.org_id) org_id
554: FROM ' ||
555: g_ar_distributions_all || ', ' ||
556: g_ar_cash_receipt_history_all || ', ' ||
557: g_ar_cash_receipts_all || ', ' ||
558: g_ar_receipt_methods || ' , ' ||
559: 'ar_ccid_by_gl_accounts glc
560: WHERE crh.gl_date between :p_start_date and :p_end_date
561: AND crh.cash_receipt_history_id = ard.source_id

Line 660: g_ar_cash_receipts_all || ', ' ||

656: max(ard.org_id) org_id
657: FROM ' ||
658: g_ar_distributions_all || ', ' ||
659: g_ar_misc_cash_dists_all || ', ' ||
660: g_ar_cash_receipts_all || ', ' ||
661: g_ar_receipt_methods || ', ' ||
662: ' ar_ccid_by_gl_accounts glc
663: WHERE mcd.gl_date between :p_start_date and :p_end_date
664: AND mcd.misc_cash_distribution_id = ard.source_id

Line 1501: g_ar_cash_receipts_all := 'ar_cash_receipts_all cr';

1497: g_ar_adjustments_all := 'ar_adjustments_all adj';
1498: g_ar_cash_receipt_history := 'ar_cash_receipt_history crh';
1499: g_ar_cash_receipt_history_all := 'ar_cash_receipt_history_all crh';
1500: g_ar_cash_receipts := 'ar_cash_receipts cr';
1501: g_ar_cash_receipts_all := 'ar_cash_receipts_all cr';
1502: --{Replaced
1503: -- g_ar_distributions := 'ar_distributions ard';
1504: g_ar_distributions := 'ar_xla_ard_lines_v ard';
1505: -- g_ar_distributions_all := 'ar_distributions_all ard';

Line 1535: g_ar_cash_receipts_all := 'ar_cash_receipts_all_mrc_v cr';

1531: g_ar_adjustments_all := 'ar_adjustments_all_mrc_v adj';
1532: g_ar_cash_receipt_history := 'ar_cash_receipt_hist_mrc_v crh';
1533: g_ar_cash_receipt_history_all := 'ar_cash_receipt_hist_all_mrc_v crh';
1534: g_ar_cash_receipts := 'ar_cash_receipts cr';
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';