APPS.JTF_RS_DEFAULT_GROUPS_CONC_PUB dependencies on FND_STATS

Line 327: fnd_stats.gather_table_stats(ownname => l_table_owner, tabname => 'JTF_RS_DEFAULT_GROUPS_INT',

323: ||' TABLESPACE '||l_index_tblspace
324: ||' NOLOGGING PARALLEL (DEGREE '||f_get_degree_of_parallelism||' ) ';
325:
326:
327: fnd_stats.gather_table_stats(ownname => l_table_owner, tabname => 'JTF_RS_DEFAULT_GROUPS_INT',
328: percent=>5, degree=>f_get_degree_of_parallelism, granularity=>'ALL',cascade=>TRUE);
329:
330: -------------Truncate the Staging table ---------
331:

Line 580: fnd_stats.gather_table_stats(ownname => l_table_owner, tabname => 'JTF_RS_DEFAULT_GROUPS_STAGE',

576:
577: -- analyze the Main table
578: l_stage := 'Stage=ANALYZING_JTF_RS_DEFAULT_GROUPS_STAGE_TABLE';
579:
580: fnd_stats.gather_table_stats(ownname => l_table_owner, tabname => 'JTF_RS_DEFAULT_GROUPS_STAGE',
581: percent=>5, degree=>f_get_degree_of_parallelism, granularity=>'ALL',cascade=>TRUE);
582:
583: -- Now compare data in recently refreshed table JTF_RS_DEFAULT_GROUPS_STAGE (new) with
584: -- previously populated table JTF_RS_DEFAULT_GROUPS (old) (final incremental table)

Line 631: fnd_stats.gather_table_stats(ownname => l_table_owner, tabname => 'JTF_RS_DEFAULT_GROUPS',

627:
628: -- analyze Staging table
629: l_stage := 'Stage=ANALYZING_JTF_RS_DEFAULT_GROUPS_TABLE';
630:
631: fnd_stats.gather_table_stats(ownname => l_table_owner, tabname => 'JTF_RS_DEFAULT_GROUPS',
632: percent=>5, degree=>f_get_degree_of_parallelism, granularity=>'ALL',cascade=>TRUE);
633:
634: EXECUTE IMMEDIATE 'ALTER SESSION DISABLE PARALLEL DML';
635: --EXECUTE IMMEDIATE 'ALTER SESSION SET SQL_TRACE=FALSE';