APPS.OZF_REFRESH_VIEW_PVT dependencies on FND_APPLICATION

Line 108: fnd_application a, fnd_oracle_userid u

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'
110: and a.application_id = i.application_id
111: and u.oracle_id = i.oracle_id)
112: AND table_name = p_table_name;

Line 119: fnd_application a, fnd_oracle_userid u

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'
121: and a.application_id = i.application_id
122: and u.oracle_id = i.oracle_id)
123: AND table_name = p_table_name;

Line 135: fnd_application a,

131:
132: select u.oracle_username
133: into ls_owner
134: from fnd_product_installations i,
135: fnd_application a,
136: fnd_oracle_userid u
137: where a.application_short_name = 'OZF'
138: and a.application_id = i.application_id
139: and u.oracle_id = i.oracle_id;