DBA Data[Home] [Help]

APPS.MSD_WS_DEM_RENAME_FORECAST dependencies on DBA_OBJECTS

Line 634: FROM dba_objects

630: x_schema := apps.fnd_profile.VALUE('MSD_DEM_SCHEMA');
631:
632: /*Check if the Materialized view exists*/
633: SELECT object_name into x_mview
634: FROM dba_objects
635: WHERE owner = x_schema
636: AND object_type = 'MATERIALIZED VIEW'
637: AND object_name = upper(mviewname)
638: ORDER BY created DESC;