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_PJP_PRG_PERF_ALL dependencies on DBA_INDEXES

Line 80: FROM dba_indexes

76: -- Gather index stats
77:
78: FOR ind_lp IN (SELECT index_name
79: , partitioned
80: FROM dba_indexes
81: WHERE table_name = p_tabname
82: AND table_owner = p_ownname) LOOP
83:
84: FND_STATS.GATHER_INDEX_STATS(ownname => p_ownname

Line 2336: FROM dba_indexes

2332:
2333: /* Added for Bug 13813361 Start */
2334: IF PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then
2335: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
2336: FROM dba_indexes
2337: WHERE table_name = 'PJI_FP_XBS_ACCUM_F'
2338: AND table_owner = l_pji_schema ) LOOP
2339: EXECUTE IMMEDIATE 'ALTER INDEX '||ind_lp.ind_name||' UNUSABLE';
2340:

Line 2509: FROM dba_indexes

2505:
2506: /* Added for Bug 13813361 Start */
2507: IF PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then
2508: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
2509: FROM dba_indexes
2510: WHERE table_name = 'PJI_FP_XBS_ACCUM_F'
2511: AND table_owner = l_pji_schema ) LOOP
2512: EXECUTE IMMEDIATE 'ALTER INDEX '||ind_lp.ind_name||' REBUILD PARALLEL';
2513: END LOOP;

Line 4536: FROM dba_indexes

4532:
4533: /* Disable Indexes PJI_FP_XBS_ACCUM_F*/
4534: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
4535: , partitioned
4536: FROM dba_indexes
4537: WHERE table_name = 'PJI_FP_XBS_ACCUM_F'
4538: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME
4539: AND status <> 'UNUSABLE') LOOP
4540:

Line 4554: FROM dba_indexes

4550:
4551: /* Disable Indexes PJI_FP_AGGR_PJP2*/
4552: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
4553: , partitioned
4554: FROM dba_indexes
4555: WHERE table_name = 'PJI_FP_AGGR_PJP2'
4556: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME
4557: AND status <> 'UNUSABLE') LOOP
4558:

Line 4572: FROM dba_indexes

4568:
4569: /* Disable Indexes PJI_MERGE_HELPER*/
4570: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
4571: , partitioned
4572: FROM dba_indexes
4573: WHERE table_name = 'PJI_MERGE_HELPER'
4574: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME
4575: AND status <> 'UNUSABLE') LOOP
4576:

Line 4962: FROM dba_indexes

4958:
4959: /* Rebuild indexes on PJI_FP_XBS_ACCUM_F*/
4960: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
4961: , partitioned
4962: FROM dba_indexes
4963: WHERE table_name = 'PJI_FP_XBS_ACCUM_F'
4964: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME) LOOP
4965:
4966: IF ind_lp.partitioned = 'YES' THEN

Line 4977: FROM dba_indexes

4973:
4974: /* Rebuild indexes on PJI_FP_AGGR_PJP2*/
4975: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
4976: , partitioned
4977: FROM dba_indexes
4978: WHERE table_name = 'PJI_FP_AGGR_PJP2'
4979: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME) LOOP
4980:
4981: IF ind_lp.partitioned = 'YES' THEN

Line 4991: FROM dba_indexes

4987:
4988: /* Rebuild indexes on PJI_MERGE_HELPER*/
4989: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
4990: , partitioned
4991: FROM dba_indexes
4992: WHERE table_name = 'PJI_MERGE_HELPER'
4993: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME) LOOP
4994:
4995: IF ind_lp.partitioned = 'YES' THEN

Line 5433: FROM dba_indexes

5429:
5430: -- Put indexes back PJI_FP_XBS_ACCUM_F
5431: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
5432: , partitioned
5433: FROM dba_indexes
5434: WHERE table_name = 'PJI_FP_XBS_ACCUM_F'
5435: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME) LOOP
5436:
5437: IF ind_lp.partitioned = 'YES' THEN

Line 5447: FROM dba_indexes

5443:
5444: -- Put indexes back PJI_FP_AGGR_PJP2
5445: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
5446: , partitioned
5447: FROM dba_indexes
5448: WHERE table_name = 'PJI_FP_AGGR_PJP2'
5449: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME) LOOP
5450:
5451: IF ind_lp.partitioned = 'YES' THEN

Line 5461: FROM dba_indexes

5457:
5458: -- Put indexes back PJI_MERGE_HELPER
5459: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
5460: , partitioned
5461: FROM dba_indexes
5462: WHERE table_name = 'PJI_MERGE_HELPER'
5463: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME) LOOP
5464:
5465: IF ind_lp.partitioned = 'YES' THEN

Line 21624: FROM dba_indexes

21620:
21621: /* Drop Indexes */
21622: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
21623: , partitioned
21624: FROM dba_indexes
21625: WHERE table_name = 'PJI_FP_AGGR_PJP2'
21626: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME
21627: AND status <> 'UNUSABLE') LOOP
21628:

Line 25819: FROM dba_indexes

25815: /* Added for bug 13897252 starts */
25816: -- Put the indexes back
25817: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
25818: , partitioned
25819: FROM dba_indexes
25820: WHERE table_name = 'PJI_FP_AGGR_PJP2'
25821: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME) LOOP
25822:
25823: IF ind_lp.partitioned = 'YES' THEN

Line 25839: FROM dba_indexes

25835:
25836: -- Put indexes back
25837: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
25838: , partitioned
25839: FROM dba_indexes
25840: WHERE table_name = 'PJI_FP_AGGR_PJP2'
25841: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME) LOOP
25842:
25843: IF ind_lp.partitioned = 'YES' THEN