APPS.MSD_DEM_CREATE_DEM_SEED SQL Statements

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

Line: 105

	    l_stmt_get_code := ' select display_units from ' || DEMANTRA_SCHEMA || '.display_units ' ||
	                       ' where display_units = ''' || l_ebs_entity_name || '''' ;

Line: 131

 	        l_stmt_display_unit_id := ' select max(display_units_id)+1 from ' || DEMANTRA_SCHEMA || '.display_units ';

Line: 139

	        l_stmt := ' insert into ' || DEMANTRA_SCHEMA || '.display_units ' ||
	                  ' (DISPLAY_UNITS_ID, DISPLAY_UNITS, DATA_TABLE, DATA_FIELD, DATA_EXPRESSION) ' ||
	                  ' values (:1,:2,''t_ep_item'',:3,NULL) ';

Line: 165

	    l_stmt_get_code := ' select real_value from ' || DEMANTRA_SCHEMA || '.real_values ' ||
         	               ' where real_value = ''' || l_ebs_entity_name || '''' ;

Line: 192

	        l_stmt := ' insert into ' || DEMANTRA_SCHEMA || '.real_values ' ||
	                  ' (REAL_VALUE_ID, REAL_VALUE, REAL_TABLE, CALCULATION_TYPE, IS_DEFAULT) ' ||
	                  ' values (' || DEMANTRA_SCHEMA || '.' || REAL_VALUES_SEQ || '.nextval,:1,:2,2,NULL) ';

Line: 222

	l_stmt_get_component := 'select dcm_product_id from ' || DEMANTRA_SCHEMA || '.dcm_products where product_name = ''' || DM_COMPONENT || '''';

Line: 231

	l_stmt_user_id := 'select user_id from ' || DEMANTRA_SCHEMA || '.user_id where lower(user_name) = ''dm''';

Line: 239

	l_stmt_query_id := 'select tq.id from ' ||
	       		    DEMANTRA_SCHEMA || '.transfer_list tl, ' ||
			    DEMANTRA_SCHEMA || '.transfer_query tq ' ||
			   ' where name like ''EBS Price List''' ||
			   ' and tq.transfer_id = tl.id ' ;

Line: 258

	    l_stmt_get_code := ' select display_units from ' || DEMANTRA_SCHEMA || '.display_units ' ||
	              ' where display_units = ''' || l_ebs_entity_name || '''' ;

Line: 290

	        l_stmt_display_unit_id := ' select max(display_units_id)+1 from ' || DEMANTRA_SCHEMA || '.display_units ';

Line: 298

		l_stmt := ' insert into ' || DEMANTRA_SCHEMA || '.display_units ' ||
		          ' (DISPLAY_UNITS_ID, DISPLAY_UNITS, DATA_TABLE, DATA_FIELD, DATA_EXPRESSION) ' ||
		          ' values (:1,:2,''sales_data'',:3,NULL) ';

Line: 304

	        l_stmt_series_id := 'select ' || DEMANTRA_SCHEMA || '.' || COMPUTED_FIELDS_SEQ || '.nextval from dual';

Line: 312

	        l_stmt_disp_order_id := ' select max(disp_order)+1 from ' || DEMANTRA_SCHEMA || '.computed_fields ';

Line: 321

	        l_stmt_comp := 'INSERT INTO ' || DEMANTRA_SCHEMA || '.COMPUTED_FIELDS("FORECAST_TYPE_ID",   "COMPUTED_NAME",   "EXP_TEMPLATE",   "DISP_COLOR",   "DISP_LSTYLE",   "DISP_LSYMBOL",   ' ||
                     ' "PRINT_COLOR",   "PRINT_LSTYLE",   "PRINT_LSYMBOL",   "DISP_ORDER",   "INFO_TYPE",   "TABLE_FORMAT",   ' ||
                     ' "DO_HAVING",   "COMPUTED_TITLE",   "FIELD_TYPE",   "SUM_FUNC",   "MODE_1",   "MODE_COLOR",   "SCALEBLE",   ' ||
                     ' "TIME_AVG",   "MODULE_TYPE",   "DEPENDANTS",   "EDITABLE",   "IS_PROPORTION",   "NULL_AS_ZERO",   "DBNAME",   ' ||
                     ' "IS_DDLB",   "IS_CHECK",   "SERIES_WIDTH",   "DROPDOWN_TABLE_NAME",   "WEB_FORMULA",   "IS_DEFAULT",   ' ||
                     ' "HINT_MESSAGE",   "COMPUTEDFIELD_EXPRESSION",   "CLIENT_EXP_DISP",   "HIST_PRED_TYPE",   "ITEMCHANGE",   ' ||
                     ' "LOCK_EXP",   "DATA_TABLE_NAME",   "COMP_DEPEND_ORDER",   "DEPEND_ON_EXP_SERVER",   "BACKGROUND_COLOR_EXP",   ' ||
                     ' "SYNCRO_FIELD",   "LOCK_EXP_DISP",   "BACKGROUND_EXP_DISP",   "WEB_LOCK_EXPRESSION",   "ATTRIBUTES_DEPENDENTS",   ' ||
                     ' "CALCULATION_METHOD",   "LOOP_NUMBER",   "MOVE_UPD_BET_FORE",   "MOVE_FROM_SALES_TO_FOR",   "LOOKUP_TYPE",   ' ||
                     ' "LOOKUP_TABLE",   "LOOKUP_DISPLAY_FIELD",   "LOOKUP_DATA_FIELD",   "LOOKUP_EXTRA_FROM",   "LOOKUP_EXTRA_WHERE",   ' ||
                     ' "COL_SERIES_WIDTH",   "IS_RANKING",   "PROP_CALC_SERIES",   "UNLINKED_LEVEL_ID",   "UPDATE_BY_SERIES_ID",   ' ||
                     ' "EXTRA_FROM",   "EXTRA_WHERE",   "BASE_LEVEL",   "COLOR_DEPENDANTS",   "LOCK_EXP_DEPENDANTS",   "EXPRESSION_TYPE",   ' ||
                     ' "INT_AGGR_FUNC",   "WAVG_BY_SERIES",   "AGGR_BY",   "SUMMARY_LINE_EXP",   "SUMMARY_LINE_EXP_DISP",   ' ||
                     ' "SUMMARY_LINE_DEPENDENTS",   "PRESERVATION_TYPE",   "FILTER_EXP",   "FILTER_EXP_DISP",   "FILTER_EXP_DEPENDANTS",   ' ||
                     ' "FILTER_EXP_COL_DEPENDANTS",   "IS_EDITABLE_SUMMARY",   "MOVE_PRESERVATION_TYPE",   "TABLE_ID",   "DATA_TYPE",   ' ||
                     ' "SAME_VAL_UPDATE") VALUES(' || l_series_id ||
                     ',   :1,   ''avg(branch_data.' || lower(l_ebs_entity_name) || ')'',   255,   1,   1,   255,   1,   1,   :2,   1,   NULL,   0,   :3,   ' ||
                     '  ''1'',   ''avg'',   NULL,   NULL,   0,   NULL,   0,   NULL,   0,   0,   0,   :4,   0,   0,   250,   NULL,   NULL,   0,   NULL, ' ||
                     ' NULL,   NULL,   3,   NULL,   NULL,   ''branch_data'',   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,' ||
                     ' NULL,   0,   NULL,   NULL,   NULL,   NULL,   NULL,   10,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   0,   NULL,   NULL,   1,   ''Avg'',   ' ||
                     ' NULL,   0,   NULL,   NULL,   NULL,   3,   NULL,   NULL,   NULL,   NULL,   0,   3,   NULL,   1,   0)';

Line: 343

	        dbms_output.put_line('Inserting into computed_fields');

Line: 347

		l_stmt := 'insert into ' || DEMANTRA_SCHEMA || '.dcm_products_series' ||
							' (dcm_product_id ,series_id) ' ||
							' (select :1, :2 from dual)';

Line: 353

		l_stmt := 'insert into ' || DEMANTRA_SCHEMA || '.user_security_series '  ||
							' (user_id, series_id ) ' ||
							' values (:1, :2)';

Line: 362

		l_stmt := 'insert into ' || DEMANTRA_SCHEMA || '.transfer_query_series '
		          || '(id, series_id, load_option, purge_option)'
		          || ' values '
		          || ' (:1,:2,2,0)';