APPS.JTY_TERR_DENORM_RULES_PVT dependencies on DBA_INDEXES

Line 65: FROM dba_indexes B

61: AND A.build_index_flag = 'Y'
62: -- the condition below is necessary for incremental mode where the index may be already present
63: AND NOT EXISTS (
64: SELECT 1
65: FROM dba_indexes B
66: WHERE B.index_name = A.index_name
67: AND B.owner = l_ora_username)
68: ORDER BY A.index_name;
69:

Line 95: dba_indexes B

91: Cursor getDropIndexCandidates(cl_source_id in number, cl_owner in varchar2) IS
92: SELECT A.index_name,
93: B.owner
94: FROM jty_terr_values_idx_header A,
95: dba_indexes B
96: WHERE A.source_id = p_source_id
97: AND A.build_index_flag = 'N'
98: AND A.index_name = B.index_name
99: AND B.owner = cl_owner;

Line 2196: FROM DBA_INDEXES aidx

2192: l_jtf_schema VARCHAR2(30);
2193:
2194: Cursor getIndexList(cl_table_name IN VARCHAR2, cl_owner IN VARCHAR2) IS
2195: SELECT aidx.owner, aidx.INDEX_NAME
2196: FROM DBA_INDEXES aidx
2197: WHERE aidx.table_name = cl_table_name
2198: AND aidx.table_owner = cl_owner
2199: AND aidx.index_name like 'JTY_DNM_ATTR_VAL%';
2200:

Line 2203: FROM DBA_INDEXES aidx

2199: AND aidx.index_name like 'JTY_DNM_ATTR_VAL%';
2200:
2201: Cursor getDeaIndexList(cl_table_name IN VARCHAR2, cl_owner IN VARCHAR2) IS
2202: SELECT aidx.owner, aidx.INDEX_NAME
2203: FROM DBA_INDEXES aidx
2204: WHERE aidx.table_name = cl_table_name
2205: AND aidx.table_owner = cl_owner
2206: AND aidx.index_name like 'JTY_DEA_ATTR_VAL%';
2207: