APPS.BIS_CREATE_REQUESTSET dependencies on USER_SYNONYMS

Line 1654: FROM all_mviews mv, user_synonyms s

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: );**/

Line 1668: FROM all_mviews mv, user_synonyms s

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:

Line 1682: FROM user_synonyms s, all_tables t

1678: WHERE owner = p_apps_schema_name
1679: AND Upper(table_name) = Upper(p_obj_name))
1680: UNION ALL
1681: (SELECT s.table_owner owner
1682: FROM user_synonyms s, all_tables t
1683: WHERE t.owner = s.table_owner
1684: AND t.table_name = s.table_name
1685: AND t.table_name = Upper(p_obj_name));**/
1686:

Line 1689: FROM user_synonyms s, all_tables t

1685: AND t.table_name = Upper(p_obj_name));**/
1686:
1687: cursor c_tab_owner1 is
1688: SELECT s.table_owner owner
1689: FROM user_synonyms s, all_tables t
1690: WHERE t.owner = s.table_owner
1691: AND t.table_name = s.table_name
1692: AND s.synonym_name = Upper(p_obj_name);
1693: