APPS.EDW_FACT_SV SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 29

	SELECT flex_view_name, generated_view_name, collection_view_name
	FROM edw_source_views
	WHERE upper(object_name) = p_fact_name
	AND version =edw_gen_view.g_version;

Line: 92

  select attribute_name, attribute_type
  from edw_attribute_properties
  where skip_flag = 'Y'
    and object_short_name = p_object_short_name;

Line: 128

	srcview := 'CREATE OR REPLACE FORCE VIEW '||g_collection_view_name||' AS SELECT ';

Line: 151

	stmt := ' SELECT distinct column_name , data_type FROM all_tab_columns@'||edw_gen_view.g_source_db_link;

Line: 613

CURSOR 		c   IS SELECT  fk_physical_name, b.dimension_short_name dimension_short_name,
       		a.value_set_id value_set_id, segment_name, flex_field_type,
	        structure_num , value_set_type, instance_code, id_flex_code, structure_name, parent_value_set_id
	        FROM edw_flex_seg_mappings a, edw_fact_flex_fk_maps b
	        WHERE b.fact_short_name = pFactName
	        AND b.enabled_flag = 'Y'
	        AND b.dimension_short_name = a.dimension_short_name
		AND a.instance_code = edw_gen_view.g_instance
		        AND (b.fk_physical_name = pAttributeName
			or b.fk_physical_name = pAttributeName||'_KEY')
		AND NOT EXISTS( select 1 from edw_flex_seg_mappings c
				where c.parent_value_set_id = a.value_set_id
				and a.instance_code = c.instance_code
				and a.dimension_short_name = c.dimension_short_name
				and a.structure_num = c.structure_num);

Line: 672

                stmt := ' SELECT segment_name, structure_num FROM edw_flex_seg_mappings'||
                        ' WHERE value_set_id = :s1 AND ';