APPS.AR_CUMULATIVE_BALANCE_REPORT dependencies on AR_RECEIPT_METHODS

Line 25: IS TABLE OF ar_receipt_methods.name%TYPE

21: IS TABLE OF gl_code_combinations.segment1%TYPE
22: INDEX BY BINARY_INTEGER;
23:
24: TYPE trx_type_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

Line 122: g_ar_receipt_methods 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;
120: g_ar_receivable_apps VARCHAR2(40) DEFAULT NULL;
121: g_ar_receivable_apps_all VARCHAR2(40) DEFAULT NULL;
122: g_ar_receipt_methods VARCHAR2(40) DEFAULT NULL;
123: g_ra_cust_trx_types VARCHAR2(40) DEFAULT NULL;
124: g_ra_cust_trx_types_all VARCHAR2(40) DEFAULT NULL;
125: g_ar_transaction_history VARCHAR2(40) DEFAULT NULL;
126: g_ar_transaction_history_all VARCHAR2(40) DEFAULT NULL;

Line 271: || g_ar_receipt_methods || '

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
275: )

Line 292: || g_ar_receipt_methods || '

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
296: )

Line 558: g_ar_receipt_methods || ' , ' ||

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
562: AND ard.source_table = ''CRH''

Line 661: g_ar_receipt_methods || ', ' ||

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
665: AND ard.source_table = ''MCD''

Line 1520: g_ar_receipt_methods := 'ar_receipt_methods rm';

1516: g_ar_misc_cash_dists := 'ar_misc_cash_distributions mcd';
1517: g_ar_misc_cash_dists_all := 'ar_misc_cash_distributions_all mcd';
1518: g_ar_receivable_apps := 'ar_receivable_applications ra';
1519: g_ar_receivable_apps_all := 'ar_receivable_applications_all ra';
1520: g_ar_receipt_methods := 'ar_receipt_methods rm';
1521: g_ra_cust_trx_types := 'ra_cust_trx_types ctt';
1522: g_ra_cust_trx_types_all := 'ra_cust_trx_types_all ctt';
1523: g_ar_transaction_history := 'ar_transaction_history br';
1524: g_ar_transaction_history_all := 'ar_transaction_history_all br';

Line 1546: g_ar_receipt_methods := 'ar_receipt_methods rm';

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';
1544: g_ar_receivable_apps := 'ar_receivable_apps_mrc_v ra';
1545: g_ar_receivable_apps_all := 'ar_receivable_apps_all_mrc_v ra';
1546: g_ar_receipt_methods := 'ar_receipt_methods rm';
1547: g_ra_cust_trx_types := 'ra_cust_trx_types ctt';
1548: g_ra_cust_trx_types_all := 'ra_cust_trx_types_all ctt';
1549: g_ar_transaction_history := 'ar_transaction_history br';
1550: g_ar_transaction_history_all := 'ar_transaction_history_all br';