APPS.JTY_TERR_DENORM_RULES_PVT dependencies on DBA_INDEXES

Line 77: FROM dba_indexes B

73: AND A.build_index_flag = 'Y'
74: -- the condition below is necessary for incremental mode where the index may be already present
75: AND NOT EXISTS (
76: SELECT 1
77: FROM dba_indexes B
78: WHERE B.index_name = A.index_name
79: AND B.owner = l_ora_username)
80: ORDER BY A.index_name;
81:

Line 107: dba_indexes B

103: Cursor getDropIndexCandidates(cl_source_id in number, cl_owner in varchar2) IS
104: SELECT A.index_name,
105: B.owner
106: FROM jty_terr_values_idx_header A,
107: dba_indexes B
108: WHERE A.source_id = p_source_id
109: AND A.build_index_flag = 'N'
110: AND A.index_name = B.index_name
111: AND B.owner = cl_owner;

Line 117: dba_indexes B

113: Cursor getDeaDropIndexCandidates(cl_source_id in number, cl_owner in varchar2) IS
114: SELECT A.index_name,
115: B.owner
116: FROM jty_dea_values_idx_header A,
117: dba_indexes B
118: WHERE A.source_id = p_source_id
119: AND A.build_index_flag = 'N'
120: AND A.index_name = B.index_name
121: AND B.owner = cl_owner;

Line 2315: FROM DBA_INDEXES aidx

2311: l_jtf_schema VARCHAR2(30);
2312:
2313: Cursor getIndexList(cl_table_name IN VARCHAR2, cl_owner IN VARCHAR2) IS
2314: SELECT aidx.owner, aidx.INDEX_NAME
2315: FROM DBA_INDEXES aidx
2316: WHERE aidx.table_name = cl_table_name
2317: AND aidx.table_owner = cl_owner
2318: AND aidx.index_name like 'JTY_DNM_ATTR_VAL%';
2319:

Line 2322: FROM DBA_INDEXES aidx

2318: AND aidx.index_name like 'JTY_DNM_ATTR_VAL%';
2319:
2320: Cursor getDeaIndexList(cl_table_name IN VARCHAR2, cl_owner IN VARCHAR2) IS
2321: SELECT aidx.owner, aidx.INDEX_NAME
2322: FROM DBA_INDEXES aidx
2323: WHERE aidx.table_name = cl_table_name
2324: AND aidx.table_owner = cl_owner
2325: AND aidx.index_name like 'JTY_DEA_ATTR_VAL%';
2326: