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 297: || g_ar_receipt_methods || '

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

Line 318: || g_ar_receipt_methods || '

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

Line 584: g_ar_receipt_methods || ' , ' ||

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

Line 687: g_ar_receipt_methods || ', ' ||

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

Line 1549: g_ar_receipt_methods := 'ar_receipt_methods rm';

1545: g_ar_misc_cash_dists := 'ar_misc_cash_distributions mcd';
1546: g_ar_misc_cash_dists_all := 'ar_misc_cash_distributions_all mcd';
1547: g_ar_receivable_apps := 'ar_receivable_applications ra';
1548: g_ar_receivable_apps_all := 'ar_receivable_applications_all ra';
1549: g_ar_receipt_methods := 'ar_receipt_methods rm';
1550: g_ra_cust_trx_types := 'ra_cust_trx_types ctt';
1551: g_ra_cust_trx_types_all := 'ra_cust_trx_types_all ctt';
1552: g_ar_transaction_history := 'ar_transaction_history br';
1553: g_ar_transaction_history_all := 'ar_transaction_history_all br';

Line 1575: g_ar_receipt_methods := 'ar_receipt_methods rm';

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';
1573: g_ar_receivable_apps := 'ar_receivable_apps_mrc_v ra';
1574: g_ar_receivable_apps_all := 'ar_receivable_apps_all_mrc_v ra';
1575: g_ar_receipt_methods := 'ar_receipt_methods rm';
1576: g_ra_cust_trx_types := 'ra_cust_trx_types ctt';
1577: g_ra_cust_trx_types_all := 'ra_cust_trx_types_all ctt';
1578: g_ar_transaction_history := 'ar_transaction_history br';
1579: g_ar_transaction_history_all := 'ar_transaction_history_all br';