DBA Data[Home] [Help]

APPS.MSC_REFRESH_MV dependencies on ALL_OBJECTS

Line 24: FROM all_objects

20: AND b.application_id= p_schema_id;
21:
22: Cursor mv_exist(p_mv_trim_name varchar2, p_schema_name varchar2) IS
23: SELECT 1
24: FROM all_objects
25: WHERE object_name = p_mv_trim_name
26: AND owner = p_schema_name;
27:
28: BEGIN