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

Line 441: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_ACT1' , l_high_rows, l_high_blocks, 225);

437: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
438: l_degree := PJI_UTILS.GET_DEGREE_OF_PARALLELISM();
439:
440: -- non-partitioned tables
441: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_ACT1' , l_high_rows, l_high_blocks, 225);
442: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_ACT2' , l_high_rows, l_high_blocks, 225);
443: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_ACT4' , l_high_rows, l_high_blocks, 225);
444: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN1' , l_high_rows, l_high_blocks, 225);
445: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN2' , l_high_rows, l_high_blocks, 225);

Line 442: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_ACT2' , l_high_rows, l_high_blocks, 225);

438: l_degree := PJI_UTILS.GET_DEGREE_OF_PARALLELISM();
439:
440: -- non-partitioned tables
441: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_ACT1' , l_high_rows, l_high_blocks, 225);
442: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_ACT2' , l_high_rows, l_high_blocks, 225);
443: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_ACT4' , l_high_rows, l_high_blocks, 225);
444: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN1' , l_high_rows, l_high_blocks, 225);
445: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN2' , l_high_rows, l_high_blocks, 225);
446: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_DLY_RATES', l_low_rows, l_low_blocks, 75);

Line 443: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_ACT4' , l_high_rows, l_high_blocks, 225);

439:
440: -- non-partitioned tables
441: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_ACT1' , l_high_rows, l_high_blocks, 225);
442: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_ACT2' , l_high_rows, l_high_blocks, 225);
443: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_ACT4' , l_high_rows, l_high_blocks, 225);
444: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN1' , l_high_rows, l_high_blocks, 225);
445: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN2' , l_high_rows, l_high_blocks, 225);
446: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_DLY_RATES', l_low_rows, l_low_blocks, 75);
447: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_ARINV' , l_med_rows, l_med_blocks, 150);

Line 444: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN1' , l_high_rows, l_high_blocks, 225);

440: -- non-partitioned tables
441: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_ACT1' , l_high_rows, l_high_blocks, 225);
442: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_ACT2' , l_high_rows, l_high_blocks, 225);
443: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_ACT4' , l_high_rows, l_high_blocks, 225);
444: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN1' , l_high_rows, l_high_blocks, 225);
445: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN2' , l_high_rows, l_high_blocks, 225);
446: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_DLY_RATES', l_low_rows, l_low_blocks, 75);
447: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_ARINV' , l_med_rows, l_med_blocks, 150);
448: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_DINVC' , l_med_rows, l_med_blocks, 150);

Line 445: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN2' , l_high_rows, l_high_blocks, 225);

441: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_ACT1' , l_high_rows, l_high_blocks, 225);
442: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_ACT2' , l_high_rows, l_high_blocks, 225);
443: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_ACT4' , l_high_rows, l_high_blocks, 225);
444: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN1' , l_high_rows, l_high_blocks, 225);
445: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN2' , l_high_rows, l_high_blocks, 225);
446: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_DLY_RATES', l_low_rows, l_low_blocks, 75);
447: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_ARINV' , l_med_rows, l_med_blocks, 150);
448: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_DINVC' , l_med_rows, l_med_blocks, 150);
449: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_DINVCITM' , l_med_rows, l_med_blocks, 150);

Line 446: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_DLY_RATES', l_low_rows, l_low_blocks, 75);

442: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_ACT2' , l_high_rows, l_high_blocks, 225);
443: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_ACT4' , l_high_rows, l_high_blocks, 225);
444: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN1' , l_high_rows, l_high_blocks, 225);
445: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN2' , l_high_rows, l_high_blocks, 225);
446: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_DLY_RATES', l_low_rows, l_low_blocks, 75);
447: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_ARINV' , l_med_rows, l_med_blocks, 150);
448: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_DINVC' , l_med_rows, l_med_blocks, 150);
449: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_DINVCITM' , l_med_rows, l_med_blocks, 150);
450: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_DREVN' , l_med_rows, l_med_blocks, 150);

Line 447: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_ARINV' , l_med_rows, l_med_blocks, 150);

443: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_ACT4' , l_high_rows, l_high_blocks, 225);
444: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN1' , l_high_rows, l_high_blocks, 225);
445: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN2' , l_high_rows, l_high_blocks, 225);
446: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_DLY_RATES', l_low_rows, l_low_blocks, 75);
447: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_ARINV' , l_med_rows, l_med_blocks, 150);
448: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_DINVC' , l_med_rows, l_med_blocks, 150);
449: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_DINVCITM' , l_med_rows, l_med_blocks, 150);
450: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_DREVN' , l_med_rows, l_med_blocks, 150);
451: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_FUNDG' , l_med_rows, l_med_blocks, 150);

Line 448: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_DINVC' , l_med_rows, l_med_blocks, 150);

444: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN1' , l_high_rows, l_high_blocks, 225);
445: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN2' , l_high_rows, l_high_blocks, 225);
446: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_DLY_RATES', l_low_rows, l_low_blocks, 75);
447: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_ARINV' , l_med_rows, l_med_blocks, 150);
448: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_DINVC' , l_med_rows, l_med_blocks, 150);
449: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_DINVCITM' , l_med_rows, l_med_blocks, 150);
450: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_DREVN' , l_med_rows, l_med_blocks, 150);
451: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_FUNDG' , l_med_rows, l_med_blocks, 150);
452: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_REXT_CDL' , l_high_rows, l_high_blocks, 225);

Line 449: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_DINVCITM' , l_med_rows, l_med_blocks, 150);

445: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_FIN2' , l_high_rows, l_high_blocks, 225);
446: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_DLY_RATES', l_low_rows, l_low_blocks, 75);
447: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_ARINV' , l_med_rows, l_med_blocks, 150);
448: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_DINVC' , l_med_rows, l_med_blocks, 150);
449: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_DINVCITM' , l_med_rows, l_med_blocks, 150);
450: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_DREVN' , l_med_rows, l_med_blocks, 150);
451: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_FUNDG' , l_med_rows, l_med_blocks, 150);
452: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_REXT_CDL' , l_high_rows, l_high_blocks, 225);
453: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_REXT_CRDL' , l_high_rows, l_high_blocks, 225);

Line 450: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_DREVN' , l_med_rows, l_med_blocks, 150);

446: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_DLY_RATES', l_low_rows, l_low_blocks, 75);
447: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_ARINV' , l_med_rows, l_med_blocks, 150);
448: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_DINVC' , l_med_rows, l_med_blocks, 150);
449: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_DINVCITM' , l_med_rows, l_med_blocks, 150);
450: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_DREVN' , l_med_rows, l_med_blocks, 150);
451: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_FUNDG' , l_med_rows, l_med_blocks, 150);
452: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_REXT_CDL' , l_high_rows, l_high_blocks, 225);
453: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_REXT_CRDL' , l_high_rows, l_high_blocks, 225);
454: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_REXT_ERDL' , l_high_rows, l_high_blocks, 225);

Line 451: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_FUNDG' , l_med_rows, l_med_blocks, 150);

447: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_ARINV' , l_med_rows, l_med_blocks, 150);
448: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_DINVC' , l_med_rows, l_med_blocks, 150);
449: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_DINVCITM' , l_med_rows, l_med_blocks, 150);
450: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_DREVN' , l_med_rows, l_med_blocks, 150);
451: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_FUNDG' , l_med_rows, l_med_blocks, 150);
452: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_REXT_CDL' , l_high_rows, l_high_blocks, 225);
453: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_REXT_CRDL' , l_high_rows, l_high_blocks, 225);
454: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_REXT_ERDL' , l_high_rows, l_high_blocks, 225);
455: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_PROJ_BATCH_MAP' , l_low_rows, l_low_blocks, 75);

Line 452: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_REXT_CDL' , l_high_rows, l_high_blocks, 225);

448: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_DINVC' , l_med_rows, l_med_blocks, 150);
449: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_DINVCITM' , l_med_rows, l_med_blocks, 150);
450: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_DREVN' , l_med_rows, l_med_blocks, 150);
451: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_FUNDG' , l_med_rows, l_med_blocks, 150);
452: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_REXT_CDL' , l_high_rows, l_high_blocks, 225);
453: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_REXT_CRDL' , l_high_rows, l_high_blocks, 225);
454: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_REXT_ERDL' , l_high_rows, l_high_blocks, 225);
455: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_PROJ_BATCH_MAP' , l_low_rows, l_low_blocks, 75);
456:

Line 453: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_REXT_CRDL' , l_high_rows, l_high_blocks, 225);

449: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_DINVCITM' , l_med_rows, l_med_blocks, 150);
450: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_DREVN' , l_med_rows, l_med_blocks, 150);
451: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_FUNDG' , l_med_rows, l_med_blocks, 150);
452: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_REXT_CDL' , l_high_rows, l_high_blocks, 225);
453: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_REXT_CRDL' , l_high_rows, l_high_blocks, 225);
454: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_REXT_ERDL' , l_high_rows, l_high_blocks, 225);
455: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_PROJ_BATCH_MAP' , l_low_rows, l_low_blocks, 75);
456:
457: -- gather statistics for PJI metadata tables

Line 454: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_REXT_ERDL' , l_high_rows, l_high_blocks, 225);

450: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_DREVN' , l_med_rows, l_med_blocks, 150);
451: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_FUNDG' , l_med_rows, l_med_blocks, 150);
452: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_REXT_CDL' , l_high_rows, l_high_blocks, 225);
453: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_REXT_CRDL' , l_high_rows, l_high_blocks, 225);
454: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_REXT_ERDL' , l_high_rows, l_high_blocks, 225);
455: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_PROJ_BATCH_MAP' , l_low_rows, l_low_blocks, 75);
456:
457: -- gather statistics for PJI metadata tables
458: FND_STATS.GATHER_TABLE_STATS(

Line 455: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_PROJ_BATCH_MAP' , l_low_rows, l_low_blocks, 75);

451: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_EXTR_FUNDG' , l_med_rows, l_med_blocks, 150);
452: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_REXT_CDL' , l_high_rows, l_high_blocks, 225);
453: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_REXT_CRDL' , l_high_rows, l_high_blocks, 225);
454: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_REXT_ERDL' , l_high_rows, l_high_blocks, 225);
455: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_PROJ_BATCH_MAP' , l_low_rows, l_low_blocks, 75);
456:
457: -- gather statistics for PJI metadata tables
458: FND_STATS.GATHER_TABLE_STATS(
459: ownname => l_schema

Line 458: FND_STATS.GATHER_TABLE_STATS(

454: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_REXT_ERDL' , l_high_rows, l_high_blocks, 225);
455: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_PROJ_BATCH_MAP' , l_low_rows, l_low_blocks, 75);
456:
457: -- gather statistics for PJI metadata tables
458: FND_STATS.GATHER_TABLE_STATS(
459: ownname => l_schema
460: , tabname => 'PJI_PROJ_EXTR_STATUS'
461: , percent => 10
462: , degree => l_degree

Line 464: FND_STATS.GATHER_INDEX_STATS(ownname => l_schema,

460: , tabname => 'PJI_PROJ_EXTR_STATUS'
461: , percent => 10
462: , degree => l_degree
463: );
464: FND_STATS.GATHER_INDEX_STATS(ownname => l_schema,
465: indname => 'PJI_PROJ_EXTR_STATUS_U1',
466: percent => 10);
467: -- Commenting this because the table is used in Stage2 Summarization . Bug#4997700
468: /* FND_STATS.GATHER_TABLE_STATS(

Line 468: /* FND_STATS.GATHER_TABLE_STATS(

464: FND_STATS.GATHER_INDEX_STATS(ownname => l_schema,
465: indname => 'PJI_PROJ_EXTR_STATUS_U1',
466: percent => 10);
467: -- Commenting this because the table is used in Stage2 Summarization . Bug#4997700
468: /* FND_STATS.GATHER_TABLE_STATS(
469: ownname => l_schema
470: , tabname => 'PJI_PROJECT_CLASSES'
471: , percent => 10
472: , degree => l_degree

Line 474: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,

470: , tabname => 'PJI_PROJECT_CLASSES'
471: , percent => 10
472: , degree => l_degree
473: ); */
474: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
475: tabname => 'PJI_FM_PROJ_BATCH_MAP',
476: percent => 10,
477: degree => l_degree);
478: FND_STATS.GATHER_COLUMN_STATS(ownname => l_schema,

Line 478: FND_STATS.GATHER_COLUMN_STATS(ownname => l_schema,

474: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
475: tabname => 'PJI_FM_PROJ_BATCH_MAP',
476: percent => 10,
477: degree => l_degree);
478: FND_STATS.GATHER_COLUMN_STATS(ownname => l_schema,
479: tabname => 'PJI_FM_PROJ_BATCH_MAP',
480: colname => 'EXTRACTION_TYPE',
481: percent => 10,
482: degree => l_degree);

Line 483: FND_STATS.GATHER_INDEX_STATS(ownname => l_schema,

479: tabname => 'PJI_FM_PROJ_BATCH_MAP',
480: colname => 'EXTRACTION_TYPE',
481: percent => 10,
482: degree => l_degree);
483: FND_STATS.GATHER_INDEX_STATS(ownname => l_schema,
484: indname => 'PJI_FM_PROJ_BATCH_MAP_U1',
485: percent => 10);
486:
487: END SEED_PJI_FM_STATS;