DBA Data[Home] [Help]

APPS.JTF_RS_DBI_8I_CONC_PUB dependencies on FND_STATS

Line 143: fnd_stats.gather_table_stats(ownname => l_table_owner, tabname => 'JTF_RS_DBI_MGR_GROUPS',

139: ;
140:
141: COMMIT;
142:
143: fnd_stats.gather_table_stats(ownname => l_table_owner, tabname => 'JTF_RS_DBI_MGR_GROUPS',
144: percent=>5, degree=>bis_common_parameters.get_degree_of_parallelism ,granularity=>'GLOBAL',cascade=>TRUE);
145:
146: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_table_owner||'.JTF_RS_DBI_DENORM_RES_GROUPS' ;
147:

Line 481: fnd_stats.gather_table_stats(ownname => l_table_owner, tabname => 'JTF_RS_DBI_DENORM_RES_GROUPS',

477: ||l_table_owner||'.JTF_RS_DBI_DENORM_RES_GROUPS (current_id, user_id, id) '
478: ||' TABLESPACE '||l_index_tblspace
479: ||' NOLOGGING PARALLEL (DEGREE '||bis_common_parameters.get_degree_of_parallelism||' ) ';
480:
481: fnd_stats.gather_table_stats(ownname => l_table_owner, tabname => 'JTF_RS_DBI_DENORM_RES_GROUPS',
482: percent=>5, degree=>bis_common_parameters.get_degree_of_parallelism, granularity=>'GLOBAL',cascade=>TRUE);
483:
484: ---------Commented out this code on 18th Feb 04 by NSINGHAI ------------------
485: -- we do not need first time login

Line 546: fnd_stats.gather_table_stats(ownname => l_table_owner, tabname => 'JTF_RS_DBI_DENORM_RES_GROUPS',

542: ' USING l_sysdate, l_user_id, l_bis_date, l_bis_date;
543:
544: COMMIT;
545:
546: fnd_stats.gather_table_stats(ownname => l_table_owner, tabname => 'JTF_RS_DBI_DENORM_RES_GROUPS',
547: percent=>5, degree=>bis_common_parameters.get_degree_of_parallelism, granularity=>'GLOBAL',cascade=>TRUE);
548:
549: */
550: