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

Line 20277: l_pji_fp_aggr_pjp1_n1 dba_indexes.status%TYPE := 'VALID';

20273: l_tab17 VARCHAR2(1) := 'N';
20274: l_tab18 VARCHAR2(1) := 'N'; -- Added for bug 13897252
20275: l_tab19 VARCHAR2(1) := 'N'; -- Added for bug 13897252
20276: l_debugdate VARCHAR2(20);
20277: l_pji_fp_aggr_pjp1_n1 dba_indexes.status%TYPE := 'VALID';
20278: /* Added for bug#11789673 , ends here */
20279:
20280: begin
20281:

Line 20411: select status into l_pji_fp_aggr_pjp1_n1 from sys.dba_indexes

20407: 'P' || p_worker_id);
20408: l_tab16 := 'Y';
20409: end if;
20410: if l_tab17 = 'N' then
20411: select status into l_pji_fp_aggr_pjp1_n1 from sys.dba_indexes
20412: where index_name = 'PJI_FP_AGGR_PJP1_N1';
20413: if l_pji_fp_aggr_pjp1_n1 <> 'VALID' then
20414: /* Added for bug 9676993 */
20415: execute immediate 'alter index '||l_schema||'.'||'PJI_FP_AGGR_PJP1_N1 rebuild';