APPS.EDW_BIS_VIEW_GEN SQL Statements

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

Line: 12

   select count(*) into l_count
     from user_objects
    where OBJECT_NAME = upper(p_view_name)
      and OBJECT_TYPE = 'VIEW'
      and STATUS = 'VALID';

Line: 83

        	stmt:= 'SELECT relation_name from EDW_RELATIONS_MD_V@' || l_target_link ||
  	       ' where relation_long_name = :longname and relation_type in (:fact, :dimension)';

Line: 106

       stmt := 'SELECT count(distinct FLEX_VIEW_NAME) FROM edw_source_views@' || l_target_link ||
		' where version = :version and GENERATED_VIEW_NAME <>''NULL'' ';

Line: 129

	stmt := 'SELECT distinct FLEX_VIEW_NAME FROM edw_source_views@' || l_target_link ||
		' where version = :version and GENERATED_VIEW_NAME <>''NULL'' ';

Line: 155

		SELECT generate_status, error_message into l_generate_status, l_error_message
		FROM EDW_LOCAL_GENERATION_STATUS
		WHERE flex_view_name = v_col(nCount);