DBA Data[Home] [Help]

APPS.MSD_WS_DEM_RENAME_FORECAST dependencies on DBA_OBJECTS

Line 376: FROM dba_objects

372: x_schema := apps.fnd_profile.VALUE('MSD_DEM_SCHEMA');
373:
374: /*Check if the Materialized view exists*/
375: SELECT object_name into x_mview
376: FROM dba_objects
377: WHERE owner = x_schema
378: AND object_type = 'MATERIALIZED VIEW'
379: AND object_name = upper(mviewname)
380: ORDER BY created DESC;