eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_RM_SUM_ROLLUP_RES dependencies on FND_STATS

Line 31: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,

27: return;
28: end if;
29:
30: -- implicit commit
31: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
32: tabname => 'PJI_RES_DELTA',
33: percent => 10,
34: degree => BIS_COMMON_PARAMETERS.
35: GET_DEGREE_OF_PARALLELISM);

Line 37: FND_STATS.GATHER_COLUMN_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,

33: percent => 10,
34: degree => BIS_COMMON_PARAMETERS.
35: GET_DEGREE_OF_PARALLELISM);
36: -- implicit commit
37: FND_STATS.GATHER_COLUMN_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
38: tabname => 'PJI_RES_DELTA',
39: colname => 'CHANGE_TYPE',
40: percent => 10,
41: degree => BIS_COMMON_PARAMETERS.

Line 44: FND_STATS.GATHER_COLUMN_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,

40: percent => 10,
41: degree => BIS_COMMON_PARAMETERS.
42: GET_DEGREE_OF_PARALLELISM);
43: -- implicit commit
44: FND_STATS.GATHER_COLUMN_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
45: tabname => 'PJI_RES_DELTA',
46: colname => 'RESOURCE_ID',
47: percent => 10,
48: degree => BIS_COMMON_PARAMETERS.

Line 51: FND_STATS.GATHER_COLUMN_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,

47: percent => 10,
48: degree => BIS_COMMON_PARAMETERS.
49: GET_DEGREE_OF_PARALLELISM);
50: -- implicit commit
51: FND_STATS.GATHER_COLUMN_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
52: tabname => 'PJI_RES_DELTA',
53: colname => 'PERSON_ID',
54: percent => 10,
55: degree => BIS_COMMON_PARAMETERS.

Line 3167: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_pji_schema,

3163: l_p_degree := 0;
3164: end if;
3165:
3166: /* Stats gathered for this table in availability mview refresh.
3167: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_pji_schema,
3168: TABNAME => 'PJI_ORG_DENORM',
3169: PERCENT => 10,
3170: DEGREE => l_p_degree);
3171: */

Line 3185: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_pji_schema,

3181: 'PJI_RM_WTO_F_MV',
3182: 'C',
3183: 'N');
3184: else
3185: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_pji_schema,
3186: TABNAME => 'MLOG$_PJI_RM_RES_WT_F',
3187: PERCENT => 10,
3188: DEGREE => l_p_degree);
3189: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

Line 3194: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_apps_schema,

3190: l_retcode,
3191: 'PJI_RM_WT_F_MV',
3192: 'F',
3193: 'N');
3194: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_apps_schema,
3195: TABNAME => 'MLOG$_PJI_RM_WT_F_MV',
3196: PERCENT => 10,
3197: DEGREE => l_p_degree);
3198: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

Line 3206: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,

3202: 'N');
3203: end if;
3204:
3205: if (l_extraction_type <> 'INCREMENTAL') then
3206: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,
3207: tabname => 'PJI_RM_WT_F_MV',
3208: percent => 10,
3209: degree => l_p_degree);
3210: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,

Line 3210: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,

3206: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,
3207: tabname => 'PJI_RM_WT_F_MV',
3208: percent => 10,
3209: degree => l_p_degree);
3210: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,
3211: tabname => 'PJI_RM_WTO_F_MV',
3212: percent => 10,
3213: degree => l_p_degree);
3214: end if;

Line 3280: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_pji_schema,

3276: 'PJI_RM_ORGO_F_MV',
3277: 'C',
3278: 'N');
3279: else
3280: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_pji_schema,
3281: TABNAME => 'MLOG$_PJI_RM_RES_F',
3282: PERCENT => 10,
3283: DEGREE => l_p_degree);
3284: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

Line 3289: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_apps_schema,

3285: l_retcode,
3286: 'PJI_RM_ORG_F_MV',
3287: 'F',
3288: 'N');
3289: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_apps_schema,
3290: TABNAME => 'MLOG$_PJI_RM_ORG_F_MV',
3291: PERCENT => 10,
3292: DEGREE => l_p_degree);
3293: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

Line 3301: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,

3297: 'N');
3298: end if;
3299:
3300: if (l_extraction_type <> 'INCREMENTAL') then
3301: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,
3302: tabname => 'PJI_RM_ORG_F_MV',
3303: percent => 10,
3304: degree => l_p_degree);
3305: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,

Line 3305: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,

3301: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,
3302: tabname => 'PJI_RM_ORG_F_MV',
3303: percent => 10,
3304: degree => l_p_degree);
3305: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,
3306: tabname => 'PJI_RM_ORGO_F_MV',
3307: percent => 10,
3308: degree => l_p_degree);
3309: end if;

Line 3378: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_apps_schema,

3374: l_retcode,
3375: 'PJI_RM_JOB_F_MV',
3376: 'F',
3377: 'N');
3378: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_apps_schema,
3379: TABNAME => 'MLOG$_PJI_RM_JOB_F_MV',
3380: PERCENT => 10,
3381: DEGREE => l_p_degree);
3382: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

Line 3390: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,

3386: 'N');
3387: end if;
3388:
3389: if (l_extraction_type <> 'INCREMENTAL') then
3390: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,
3391: tabname => 'PJI_RM_JOB_F_MV',
3392: percent => 10,
3393: degree => l_p_degree);
3394: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,

Line 3394: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,

3390: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,
3391: tabname => 'PJI_RM_JOB_F_MV',
3392: percent => 10,
3393: degree => l_p_degree);
3394: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,
3395: tabname => 'PJI_RM_JOBO_F_MV',
3396: percent => 10,
3397: degree => l_p_degree);
3398: end if;

Line 3455: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,

3451: 'PJI_TIME_MV',
3452: 'C',
3453: 'N');
3454:
3455: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,
3456: tabname => 'PJI_TIME_MV',
3457: percent => 10,
3458: degree => l_p_degree);
3459:

Line 3516: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,

3512: 'PJI_TIME_DAY_MV',
3513: 'C',
3514: 'N');
3515:
3516: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,
3517: tabname => 'PJI_TIME_DAY_MV',
3518: percent => 10,
3519: degree => l_p_degree);
3520:

Line 3577: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,

3573: 'PJI_TIME_TREND_MV',
3574: 'C',
3575: 'N');
3576:
3577: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,
3578: tabname => 'PJI_TIME_TREND_MV',
3579: percent => 10,
3580: degree => l_p_degree);
3581: