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 440: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_ACT1' , l_high_rows, l_high_blocks, 225);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 457: FND_STATS.GATHER_TABLE_STATS(

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

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

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

Line 467: /* FND_STATS.GATHER_TABLE_STATS(

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

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

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

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

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

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

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