APPS.EDW_DIM_SV dependencies on EDW_SOURCE_VIEWS

Line 74: select collection_view_name from edw_source_views

70:
71: Procedure getViewnameForFlexdim(dim_name in varchar2) IS
72:
73: cursor c_viewForFlexdim(obj_short_name varchar2 ) is
74: select collection_view_name from edw_source_views
75: where object_name = obj_short_name
76: order by level_name;
77:
78: BEGIN

Line 863: FROM edw_source_views

859: END IF;
860:
861: SELECT flex_view_name, generated_view_name, collection_view_name
862: INTO g_std_flex_view_name, g_std_generated_view_name, g_std_collection_view_name
863: FROM edw_source_views
864: WHERE object_name = dim_name AND level_name = level AND version =edw_gen_view.g_version;
865:
866: IF (g_log) THEN
867:

Line 898: FROM edw_source_views

894: edw_gen_view.writelog('Parameter level:'||level);
895: END IF;
896:
897: SELECT generated_view_name INTO view_name
898: FROM edw_source_views
899: WHERE object_name = dim_name AND level_name = level AND version =edw_gen_view.g_version;
900:
901: IF (g_log) THEN
902: edw_gen_view.writelog('View name for standard dimension '||dim_name || ':'||view_name);