APPS.HZ_PARTY_STAGE_SHADOW dependencies on ALL_INDEXES

Line 697: FROM sys.all_indexes i, hz_trans_attributes_vl a, hz_trans_functions_vl f

693: log('Dropping Btree Indexes on Base Staging tables');
694: IF (fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_owner1)) THEN
695: FOR IDX in (
696: SELECT OWNER||'.'||INDEX_NAME idx_name
697: FROM sys.all_indexes i, hz_trans_attributes_vl a, hz_trans_functions_vl f
698: WHERE f.attribute_id = a.attribute_id
699: AND i.owner = l_owner1
700: AND f.index_required_flag in ('Y','T')
701: AND i.INDEX_NAME = decode(a.entity_name,'PARTY','HZ_SHADOW_ST_PARTIES',

Line 4372: SELECT 1 FROM sys.all_indexes

4368: AND f.index_required_flag = 'Y'
4369: AND a.entity_name = p_entity;
4370:
4371: CURSOR check_index(cp_index_name VARCHAR2,cp_table_name VARCHAR2) IS
4372: SELECT 1 FROM sys.all_indexes
4373: WHERE INDEX_NAME=cp_index_name
4374: AND TABLE_NAME=cp_table_name and owner = l_index_owner;
4375:
4376: l_index_name VARCHAR2(255);