DBA Data[Home] [Help]

SYSTEM.AD_APPS_PRIVATE dependencies on DBA_EDITIONING_VIEWS

Line 113: FROM dba_editioning_views

109: if (p_obj_owner is not null)
110: then
111: SELECT count(1)
112: INTO l_exist
113: FROM dba_editioning_views
114: WHERE view_name=l_evname
115: AND owner=p_obj_owner;
116:
117: IF (l_exist = 0)

Line 795: FROM dba_editioning_views

791: then
792: l_evname := get_evname(object_name);
793: SELECT count(1)
794: into l_evexist
795: FROM dba_editioning_views
796: WHERE view_name=upper(l_evname)
797: AND table_name=upper(object_name)
798: AND owner=upper(target_schema);
799:

Line 1801: Dba_Editioning_Views Ev

1797: cursor synonyms_cursor is
1798: Select Nvl(Ev.View_Name,Tab.Table_Name) Target_name, Tab.table_name object_name, 'TABLE ' object_type
1799: From Dba_Tables Tab
1800: Left Outer Join
1801: Dba_Editioning_Views Ev
1802: On (Tab.Table_Name=Ev.table_Name)
1803: Where Tab.Owner=Nvl(Ev.Owner, Tab.Owner)
1804: And Tab.Owner=upper(base_schema)
1805: And Tab.Iot_Name Is Null