DBA Data[Home] [Help]

APPS.AD_MV dependencies on USER_OBJECTS

Line 131: FROM user_objects

127: WHERE table_name = mview_name
128: AND mview_name = create_mv.as_mview_name_i
129: AND NOT EXISTS (
130: SELECT null
131: FROM user_objects
132: WHERE object_type = 'MATERIALIZED VIEW'
133: AND object_name = table_name
134: AND object_name = create_mv.as_mview_name_i
135: )