APPS.AR_CUMULATIVE_BALANCE_REPORT dependencies on AR_CCID_BY_GL_ACCOUNTS

Line 13: IS TABLE OF ar_ccid_by_gl_accounts.gl_account%TYPE

9: TYPE flex_table IS TABLE OF FND_FLEX_VALUES.flex_value%TYPE
10: INDEX BY BINARY_INTEGER;
11:
12: TYPE gl_accounts_type
13: IS TABLE OF ar_ccid_by_gl_accounts.gl_account%TYPE
14: INDEX BY BINARY_INTEGER;
15:
16: TYPE components_type
17: IS TABLE OF ar_gl_acct_balances.component%TYPE

Line 539: ', ar_ccid_by_gl_accounts glc

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''
542: AND trx.complete_flag = ''Y''
543: AND dist.customer_trx_id = trx.customer_trx_id

Line 585: 'ar_ccid_by_gl_accounts glc

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''
589: AND ard.code_combination_id = glc.code_combination_id

Line 638: ' ar_ccid_by_gl_accounts glc

634: max(ard.org_id) org_id
635: FROM ' ||
636: g_ar_distributions_all || ', ' ||
637: g_ar_receivable_apps_all || ', ' ||
638: ' ar_ccid_by_gl_accounts glc
639: WHERE ra.gl_date BETWEEN :p_start_date and :p_end_date
640: AND ra.receivable_application_id = ard.source_id
641: AND ard.source_table = ''RA''
642: AND ard.code_combination_id = glc.code_combination_id '

Line 688: ' ar_ccid_by_gl_accounts glc

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''
692: AND ard.code_combination_id = glc.code_combination_id

Line 741: ' ar_ccid_by_gl_accounts glc

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
744: AND ard.source_table = ''ADJ''
745: AND ard.code_combination_id = glc.code_combination_id

Line 791: ' ar_ccid_by_gl_accounts glc

787: max(ard.org_id) org_id
788: FROM ' ||
789: g_ar_distributions_all || ', ' ||
790: g_ar_transaction_history_all || ', ' ||
791: ' ar_ccid_by_gl_accounts glc
792: WHERE br.gl_date between :p_start_date and :p_end_date
793: AND br.transaction_history_id = ard.source_id
794: AND ard.source_table = ''TH''
795: AND ard.code_combination_id = glc.code_combination_id '

Line 1156: DELETE FROM ar_ccid_by_gl_accounts;

1152: l_segment_name := get_gl_account_segment();
1153:
1154: debug('Natural segment: ' || l_segment_name);
1155:
1156: DELETE FROM ar_ccid_by_gl_accounts;
1157:
1158: debug('number of rows deleted: ' || SQL%ROWCOUNT);
1159:
1160: l_segment_str:=

Line 1168: 'INSERT INTO ar_ccid_by_gl_accounts

1164: 'GCC',
1165: 'SELECT',
1166: 'ALL');
1167: l_sql_stmt :=
1168: 'INSERT INTO ar_ccid_by_gl_accounts
1169: (
1170: code_combination_id,
1171: natural_account,
1172: gl_account,

Line 1199: fnd_stats.gather_table_stats('AR', 'AR_CCID_BY_GL_ACCOUNTS');

1195: EXECUTE IMMEDIATE l_sql_stmt ;
1196:
1197: debug('number of rows inserted: ' || SQL%ROWCOUNT);
1198:
1199: fnd_stats.gather_table_stats('AR', 'AR_CCID_BY_GL_ACCOUNTS');
1200:
1201: debug('ar_cumulative_balance_report.populate_ccids(-)');
1202:
1203: EXCEPTION