APPS.OZF_REFRESH_VIEW_PVT dependencies on ALL_INDEXES

Line 105: FROM all_indexes

101: ls_owner varchar2(10);
102:
103: CURSOR dis_obj IS
104: SELECT 'ALTER INDEX '||owner||'.'||index_name ||' UNUSABLE' sqlstmt
105: FROM all_indexes
106: WHERE table_owner = (select u.oracle_username
107: from fnd_product_installations i,
108: fnd_application a, fnd_oracle_userid u
109: where a.application_short_name = 'OZF'

Line 116: FROM all_indexes

112: AND table_name = p_table_name;
113:
114: CURSOR en_obj is
115: SELECT 'ALTER INDEX '||owner||'.'||index_name ||' REBUILD ONLINE' sqlstmt
116: FROM all_indexes
117: WHERE table_owner = (select u.oracle_username
118: from fnd_product_installations i,
119: fnd_application a, fnd_oracle_userid u
120: where a.application_short_name = 'OZF'