DBA Data[Home] [Help]

APPS.IBE_REPORTING_PVT dependencies on ALL_MVIEWS

Line 1495: From all_mviews

1491: PROCEDURE dropMview( pMode IN Varchar2, pOwner IN Varchar2,pName IN Varchar2) IS
1492:
1493: CURSOR dr_obj_mv(pOwner IN Varchar2,pName IN Varchar2) is
1494: Select 'drop materialized view '||owner||'.'||mview_name sqlstmt
1495: From all_mviews
1496: Where owner = pOwner
1497: And mview_name = pName;
1498: ddl_curs integer;
1499: Begin