1645:
1646: /**
1647: cursor c_mv_owner(p_apps_schema_name varchar2) is
1648: (SELECT owner
1649: FROM all_mviews
1650: WHERE owner = p_apps_schema_name
1651: AND Upper(mview_name) = Upper(p_obj_name))
1652: UNION ALL
1653: (SELECT s.table_owner owner
1650: WHERE owner = p_apps_schema_name
1651: AND Upper(mview_name) = Upper(p_obj_name))
1652: UNION ALL
1653: (SELECT s.table_owner owner
1654: FROM all_mviews mv, user_synonyms s
1655: WHERE mv.owner = s.table_owner
1656: AND mv.mview_name = s.table_name
1657: AND Upper(mv.mview_name) = Upper(p_obj_name)
1658: );**/
1658: );**/
1659:
1660: cursor c_mv_owner1(p_apps_schema_name varchar2) is
1661: select owner
1662: from all_mviews
1663: where owner=p_apps_schema_name
1664: and mview_name = Upper(p_obj_name);
1665:
1666: cursor c_mv_owner2 is
1664: and mview_name = Upper(p_obj_name);
1665:
1666: cursor c_mv_owner2 is
1667: SELECT s.table_owner owner
1668: FROM all_mviews mv, user_synonyms s
1669: WHERE mv.owner = s.table_owner
1670: AND mv.mview_name = s.table_name
1671: AND s.synonym_name = Upper(p_obj_name);
1672: