DBA Data[Home] [Help]

APPS.AD_ZD_MVIEW dependencies on OBJ$

Line 1747: sys.obj$ lvx

1743: end lv_changed
1744: , ad_zd_mview.get_mv_name(lvv.view_name) mv_name
1745: , mvo.created mv_changed
1746: from
1747: sys.obj$ lvx
1748: , ( select
1749: xusr.user#
1750: , xusr.ext_username user_name
1751: , ed.name edition_name

Line 1754: , (select * from sys.obj$ where owner# = 0 and type# = 57) ed

1750: , xusr.ext_username user_name
1751: , ed.name edition_name
1752: from
1753: (select * from sys.user$ where type# = 2) xusr
1754: , (select * from sys.obj$ where owner# = 0 and type# = 57) ed
1755: where xusr.spare2 = ed.obj# ) eusr
1756: , dba_views lvv
1757: , dba_objects mvo
1758: where lvv.owner in