DBA Data[Home] [Help]

APPS.JTF_RS_SRP_GROUPS_CONC_PUB dependencies on FND_STATS

Line 308: fnd_stats.gather_table_stats(ownname => l_table_owner, tabname => 'JTF_RS_SRP_GROUPS_INT',

304: ||' (salesrep_id, org_id, denorm_count, role_type_priority, role_priority) '
305: ||' TABLESPACE '||l_index_tblspace
306: ||' NOLOGGING PARALLEL (DEGREE '||f_get_degree_of_parallelism||' ) ';
307:
308: fnd_stats.gather_table_stats(ownname => l_table_owner, tabname => 'JTF_RS_SRP_GROUPS_INT',
309: percent=>5, degree=>f_get_degree_of_parallelism, granularity=>'GLOBAL',cascade=>TRUE);
310:
311: -------------Truncate the Main table ---------
312: l_stage := 'Stage=TRUNCATE_JTF_RS_SRP_GROUPS_STAGE_TABLE';

Line 570: fnd_stats.gather_table_stats(ownname => l_table_owner, tabname => 'JTF_RS_SRP_GROUPS_STAGE',

566:
567: -- analyze Staging table
568: l_stage := 'Stage=ANALYZING_JTF_RS_SRP_GROUPS_STAGE_TABLE';
569:
570: fnd_stats.gather_table_stats(ownname => l_table_owner, tabname => 'JTF_RS_SRP_GROUPS_STAGE',
571: percent=>5, degree=>f_get_degree_of_parallelism, granularity=>'GLOBAL',cascade=>TRUE);
572:
573: ----------------------------------------
574: -- Added by NSINGHAI on 13-Sep-2004 for Bug # 3882194 - to make CP Incremental

Line 624: fnd_stats.gather_table_stats(ownname => l_table_owner, tabname => 'JTF_RS_SRP_GROUPS',

620:
621: -- analyze Staging table
622: l_stage := 'Stage=ANALYZING_JTF_RS_SRP_GROUPS_TABLE';
623:
624: fnd_stats.gather_table_stats(ownname => l_table_owner, tabname => 'JTF_RS_SRP_GROUPS',
625: percent=>5, degree=>f_get_degree_of_parallelism, granularity=>'GLOBAL',cascade=>TRUE);
626:
627: ----------------------------------------
628: