DBA Data[Home] [Help]

APPS.AD_MV dependencies on USER_OBJECTS

Line 84: FROM user_objects

80: WHERE table_name = mview_name
81: AND mview_name = create_mv.as_mview_name_i
82: AND NOT EXISTS (
83: SELECT null
84: FROM user_objects
85: WHERE object_type = 'MATERIALIZED VIEW'
86: AND object_name = table_name
87: AND object_name = create_mv.as_mview_name_i
88: )