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_FM_SUM_ROLLUP_FIN dependencies on FND_STATS

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

5160: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(PJI_FM_SUM_MAIN.g_top_process,
5161: 'CONFIG_UTIL_FLAG'), 'N'));
5162:
5163: if (l_params_util_flag = 'N') then
5164: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_pji_schema,
5165: TABNAME => 'PJI_ORG_DENORM',
5166: PERCENT => 10,
5167: DEGREE => l_p_degree);
5168: end if;

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

5179: 'PJI_FP_ORGO_ET_WT_F_MV',
5180: 'C',
5181: 'N');
5182: else
5183: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_pji_schema,
5184: TABNAME => 'MLOG$_PJI_FP_PROJ_ET_WT_F',
5185: PERCENT => 10,
5186: DEGREE => l_p_degree);
5187: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

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

5188: l_retcode,
5189: 'PJI_FP_ORG_ET_WT_F_MV',
5190: 'F',
5191: 'N');
5192: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_apps_schema,
5193: TABNAME => 'MLOG$_PJI_FP_ORG_ET_WT_F_M',
5194: PERCENT => 10,
5195: DEGREE => l_p_degree);
5196: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

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

5200: 'N');
5201: end if;
5202:
5203: if (l_extraction_type <> 'INCREMENTAL') then
5204: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,
5205: tabname => 'PJI_FP_ORG_ET_WT_F_MV',
5206: percent => 10,
5207: degree => l_p_degree);
5208: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,

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

5204: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,
5205: tabname => 'PJI_FP_ORG_ET_WT_F_MV',
5206: percent => 10,
5207: degree => l_p_degree);
5208: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,
5209: tabname => 'PJI_FP_ORGO_ET_WT_F_MV',
5210: percent => 10,
5211: degree => l_p_degree);
5212: end if;

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

5262: if (l_p_degree = 1) then
5263: l_p_degree := 0;
5264: end if;
5265:
5266: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_pji_schema,
5267: TABNAME => 'PJI_PROJECT_CLASSES',
5268: PERCENT => 10,
5269: DEGREE => l_p_degree);
5270:

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

5284: l_retcode,
5285: 'PJI_FP_CLS_ET_WT_F_MV',
5286: 'F',
5287: 'N');
5288: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_apps_schema,
5289: TABNAME => 'MLOG$_PJI_FP_CLS_ET_WT_F_M',
5290: PERCENT => 10,
5291: DEGREE => l_p_degree);
5292: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

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

5296: 'N');
5297: end if;
5298:
5299: if (l_extraction_type <> 'INCREMENTAL') then
5300: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,
5301: tabname => 'PJI_FP_CLS_ET_WT_F_MV',
5302: percent => 10,
5303: degree => l_p_degree);
5304: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,

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

5300: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,
5301: tabname => 'PJI_FP_CLS_ET_WT_F_MV',
5302: percent => 10,
5303: degree => l_p_degree);
5304: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,
5305: tabname => 'PJI_FP_CLSO_ET_WT_F_MV',
5306: percent => 10,
5307: degree => l_p_degree);
5308: end if;

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

5370: 'PJI_FP_ORGO_ET_F_MV',
5371: 'C',
5372: 'N');
5373: else
5374: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_pji_schema,
5375: TABNAME => 'MLOG$_PJI_FP_PROJ_ET_F',
5376: PERCENT => 10,
5377: DEGREE => l_p_degree);
5378: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

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

5379: l_retcode,
5380: 'PJI_FP_ORG_ET_F_MV',
5381: 'F',
5382: 'N');
5383: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_apps_schema,
5384: TABNAME => 'MLOG$_PJI_FP_ORG_ET_F_MV',
5385: PERCENT => 10,
5386: DEGREE => l_p_degree);
5387: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

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

5391: 'N');
5392: end if;
5393:
5394: if (l_extraction_type <> 'INCREMENTAL') then
5395: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,
5396: tabname => 'PJI_FP_ORG_ET_F_MV',
5397: percent => 10,
5398: degree => l_p_degree);
5399: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,

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

5395: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,
5396: tabname => 'PJI_FP_ORG_ET_F_MV',
5397: percent => 10,
5398: degree => l_p_degree);
5399: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,
5400: tabname => 'PJI_FP_ORGO_ET_F_MV',
5401: percent => 10,
5402: degree => l_p_degree);
5403: end if;

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

5468: l_retcode,
5469: 'PJI_FP_CLS_ET_F_MV',
5470: 'F',
5471: 'N');
5472: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_apps_schema,
5473: TABNAME => 'MLOG$_PJI_FP_CLS_ET_F_MV',
5474: PERCENT => 10,
5475: DEGREE => l_p_degree);
5476: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

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

5480: 'N');
5481: end if;
5482:
5483: if (l_extraction_type <> 'INCREMENTAL') then
5484: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,
5485: tabname => 'PJI_FP_CLS_ET_F_MV',
5486: percent => 10,
5487: degree => l_p_degree);
5488:

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

5485: tabname => 'PJI_FP_CLS_ET_F_MV',
5486: percent => 10,
5487: degree => l_p_degree);
5488:
5489: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,
5490: tabname => 'PJI_FP_CLSO_ET_F_MV',
5491: percent => 10,
5492: degree => l_p_degree);
5493: end if;

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

5555: 'PJI_FP_ORGO_F_MV',
5556: 'C',
5557: 'N');
5558: else
5559: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_pji_schema,
5560: TABNAME => 'MLOG$_PJI_FP_PROJ_F',
5561: PERCENT => 10,
5562: DEGREE => l_p_degree);
5563: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

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

5564: l_retcode,
5565: 'PJI_FP_ORG_F_MV',
5566: 'F',
5567: 'N');
5568: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_apps_schema,
5569: TABNAME => 'MLOG$_PJI_FP_ORG_F_MV',
5570: PERCENT => 10,
5571: DEGREE => l_p_degree);
5572: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

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

5576: 'N');
5577: end if;
5578:
5579: if (l_extraction_type <> 'INCREMENTAL') then
5580: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,
5581: tabname => 'PJI_FP_ORG_F_MV',
5582: percent => 10,
5583: degree => l_p_degree);
5584: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,

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

5580: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,
5581: tabname => 'PJI_FP_ORG_F_MV',
5582: percent => 10,
5583: degree => l_p_degree);
5584: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,
5585: tabname => 'PJI_FP_ORGO_F_MV',
5586: percent => 10,
5587: degree => l_p_degree);
5588: end if;

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

5653: l_retcode,
5654: 'PJI_FP_CLS_F_MV',
5655: 'F',
5656: 'N');
5657: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_apps_schema,
5658: TABNAME => 'MLOG$_PJI_FP_CLS_F_MV',
5659: PERCENT => 10,
5660: DEGREE => l_p_degree);
5661: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(l_errbuf,

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

5665: 'N');
5666: end if;
5667:
5668: if (l_extraction_type <> 'INCREMENTAL') then
5669: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,
5670: tabname => 'PJI_FP_CLS_F_MV',
5671: percent => 10,
5672: degree => l_p_degree);
5673: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,

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

5669: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,
5670: tabname => 'PJI_FP_CLS_F_MV',
5671: percent => 10,
5672: degree => l_p_degree);
5673: FND_STATS.GATHER_TABLE_STATS(ownname => l_apps_schema,
5674: tabname => 'PJI_FP_CLSO_F_MV',
5675: percent => 10,
5676: degree => l_p_degree);
5677: end if;