CREATE MATERIALIZED VIEW "V_MODULE_LIST_M" ("PARENT_ID", "MOD_ID", "TYPE")
BUILD IMMEDIATE
USING INDEX 
REFRESH FORCE ON DEMAND
USING DEFAULT LOCAL ROLLBACK SEGMENT
USING ENFORCED CONSTRAINTS DISABLE QUERY REWRITE
AS SELECT "PARENT_ID", "MOD_ID", "TYPE" FROM V_MODULE_LIST_39;/
