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.FND_XDF_UTIL_PKG dependencies on ALL_INDEXES

Line 126: FROM ALL_INDEXES

122: NVL(DECODE(LTRIM(DEGREE), 'DEFAULT', 65536, DEGREE),0) || NVL(PARTITIONED, 'NO') ||
123: NVL(funcidx_status, 'DISABLED') || TABLE_NAME ||
124: TABLE_TYPE || NVL(ITYP_OWNER, '-1') || NVL(ITYP_NAME,'-1') || NVL(PARAMETERS, '-1') || NVL(COMPRESSION, 'DISABLED')
125: INTO l_hashstr
126: FROM ALL_INDEXES
127: WHERE index_name = p_indexname AND OWNER = p_owner;
128:
129: for c in col_cur loop
130: l_hashstr := l_hashstr || c.column_name;

Line 178: ||'FROM ALL_INDEXES , TABLE(FND_XDF_TABLE_OF_VARCHAR2_30(' || l_indexListstr ||')) FND_TAB '

174: ||'NVL(DECODE(LTRIM(DEGREE), ''DEFAULT'', 65536, DEGREE),0) || NVL(PARTITIONED, ''NO'') || '
175: ||'NVL(funcidx_status, ''DISABLED'') || TABLE_NAME || NVL(tablespace_name, '' '') || TABLE_OWNER || '
176: ||'TABLE_TYPE || NVL(ITYP_OWNER, ''-1'') || NVL(ITYP_NAME,''-1'') || NVL(PARAMETERS, ''-1'') || NVL(COMPRESSION, ''DISABLED'') hashstr,'
177: ||'index_name '
178: ||'FROM ALL_INDEXES , TABLE(FND_XDF_TABLE_OF_VARCHAR2_30(' || l_indexListstr ||')) FND_TAB '
179: ||'WHERE index_name = FND_TAB.COLUMN_VALUE AND OWNER = ''' || p_owner || ''''
180: ||' UNION ALL '
181: ||'SELECT ''NULL'', C.COLUMN_VALUE FROM TABLE(FND_XDF_TABLE_OF_VARCHAR2_30('|| l_indexListstr || ')) C '
182: ||'WHERE C.COLUMN_VALUE NOT IN '

Line 183: ||'(SELECT B.INDEX_NAME FROM ALL_INDEXES B WHERE OWNER = '''|| p_owner || ''' AND C.COLUMN_VALUE = B.INDEX_NAME) ';

179: ||'WHERE index_name = FND_TAB.COLUMN_VALUE AND OWNER = ''' || p_owner || ''''
180: ||' UNION ALL '
181: ||'SELECT ''NULL'', C.COLUMN_VALUE FROM TABLE(FND_XDF_TABLE_OF_VARCHAR2_30('|| l_indexListstr || ')) C '
182: ||'WHERE C.COLUMN_VALUE NOT IN '
183: ||'(SELECT B.INDEX_NAME FROM ALL_INDEXES B WHERE OWNER = '''|| p_owner || ''' AND C.COLUMN_VALUE = B.INDEX_NAME) ';
184:
185: --DBMS_OUTPUT.PUT_LINE(l_indexListStr);
186: --DBMS_OUTPUT.PUT_LINE(selQry);
187:

Line 243: ||' FROM ALL_INDEXES '

239: ||'NVL(PCT_INCREASE, 0) || NVL(FREELISTS, 0) || NVL(FREELIST_GROUPS, 0) || NVL(pct_free, 0) ||'
240: ||'NVL(DECODE(LTRIM(DEGREE), ''DEFAULT'', 65536, DEGREE),0) || NVL(PARTITIONED, ''NO'') ||'
241: ||'NVL(funcidx_status, ''DISABLED'') || TABLE_NAME || '
242: ||'TABLE_TYPE || NVL(ITYP_OWNER, ''-1'') || NVL(ITYP_NAME,''-1'') || NVL(PARAMETERS, ''-1'') || NVL(COMPRESSION, ''DISABLED'') hashstr'
243: ||' FROM ALL_INDEXES '
244: ||' WHERE OWNER = '''|| p_owner ||''' AND INDEX_NAME = :p_indexname ';
245:
246: for j in 1..p_indexList.count loop
247: begin