APPS.AD_ZD_PREP dependencies on DBA_OBJECTS

Line 1615: from dba_objects obj

1611: from SYSTEM.fnd_oracle_userid
1612: where read_only_flag in ('A','B', 'E', 'C', 'U'))
1613: and (syn.table_owner, syn.table_name) in
1614: (select obj.owner, obj.object_name
1615: from dba_objects obj
1616: where obj.owner = syn.table_owner -- To avoid GSCC error
1617: and obj.object_type in ('TYPE', 'PACKAGE', 'VIEW' ,
1618: 'SYNONYM','PROCEDURE',
1619: 'TRIGGER','FUNCTION'));

Line 1687: from dba_objects

1683: when no_data_found then
1684: -- check if another object with same exists?
1685: begin
1686: select object_type into l_object_type
1687: from dba_objects
1688: where owner = l_users.owner
1689: and object_name = x_synonym_name
1690: and namespace in /* not hard-coding namespace=1 */
1691: ( select namespace

Line 1692: from dba_objects

1688: where owner = l_users.owner
1689: and object_name = x_synonym_name
1690: and namespace in /* not hard-coding namespace=1 */
1691: ( select namespace
1692: from dba_objects
1693: where object_type = 'SYNONYM'
1694: and owner = 'PUBLIC'
1695: and object_name = x_synonym_name
1696: );

Line 1858: from dba_objects obj

1854: where syn.owner='PUBLIC'
1855: and syn.table_owner = x_user
1856: and (syn.table_owner, syn.table_name) in
1857: (select obj.owner, obj.object_name
1858: from dba_objects obj
1859: where obj.owner = syn.table_owner -- To avoid GSCC error
1860: and obj.object_type in ('TYPE', 'PACKAGE', 'VIEW' ,
1861: 'SYNONYM','PROCEDURE',
1862: 'TRIGGER','FUNCTION'));

Line 1890: ( select 'X' from dba_objects m

1886: where v.view_name like '%'||'#'
1887: and v.editioning_view = 'N'
1888: and v.owner =x_user
1889: and not exists
1890: ( select 'X' from dba_objects m
1891: where m.owner = v.owner
1892: and m.object_name = ad_zd_mview.get_mv_name(v.view_name)
1893: and m.object_type = 'MATERIALIZED VIEW'
1894: and m.status = 'VALID' );