APPS.MSC_CONFIG_FF SQL Statements

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

Line: 316

    update fnd_profile_option_values
    set profile_option_value = to_char(item_attr1)
    where application_id = 723
    and level_id = 10001
    and profile_option_id = (select profile_option_id
		from fnd_profile_options
		where application_id = 723
		and  profile_option_name = 'MSO_ITEM_DMD_PENALTY');

Line: 381

    update fnd_profile_option_values
    set profile_option_value = to_char(item_attr2)
    where application_id = 723
    and level_id = 10001
    and profile_option_id = (select profile_option_id
		from fnd_profile_options
		where application_id = 723
		and  profile_option_name = 'MSO_ITEM_CAP_PENALTY');

Line: 451

    update fnd_profile_option_values
    set profile_option_value = to_char(org_attr1)
    where application_id = 723
    and level_id = 10001
    and profile_option_id = (select profile_option_id
		from fnd_profile_options
		where application_id = 723
		and  profile_option_name = 'MSO_ORG_DMD_PENALTY');

Line: 516

    update fnd_profile_option_values
    set profile_option_value = to_char(org_attr2)
    where application_id = 723
    and level_id = 10001
    and profile_option_id = (select profile_option_id
		from fnd_profile_options
		where application_id = 723
		and  profile_option_name = 'MSO_ORG_ITEM_PENALTY');

Line: 582

    update fnd_profile_option_values
    set profile_option_value = to_char(org_attr3)
    where application_id = 723
    and level_id = 10001
    and profile_option_id = (select profile_option_id
		from fnd_profile_options
		where application_id = 723
		and  profile_option_name = 'MSO_ORG_RES_PENALTY');

Line: 648

    update fnd_profile_option_values
    set profile_option_value = to_char(org_attr4)
    where application_id = 723
    and level_id = 10001
    and profile_option_id = (select profile_option_id
		from fnd_profile_options
		where application_id = 723
		and  profile_option_name = 'MSO_ORG_TRSP_PENALTY');

Line: 719

    update fnd_profile_option_values
    set profile_option_value = to_char(dept_attr1)
    where application_id = 724
    and level_id = 10001
    and profile_option_id = (select profile_option_id
		from fnd_profile_options
		where application_id = 724
		and  profile_option_name = 'MSC_AGGREG_RES_NAME');

Line: 792

    update fnd_profile_option_values
    set profile_option_value = to_char(dept_attr2)
    where application_id = 723
    and level_id = 10001
    and profile_option_id = (select profile_option_id
		from fnd_profile_options
		where application_id = 723
		and  profile_option_name = 'MSO_RES_PENALTY');

Line: 862

    update fnd_profile_option_values
    set profile_option_value = to_char(supp_attr1)
    where application_id = 723
    and level_id = 10001
    and profile_option_id = (select profile_option_id
		from fnd_profile_options
		where application_id = 723
		and  profile_option_name = 'MSO_SUP_CAP_PENALTY');

Line: 933

    update fnd_profile_option_values
    set profile_option_value = to_char(subst_attr1)
    where application_id = 724
    and level_id = 10001
    and profile_option_id = (select profile_option_id
		from fnd_profile_options
		where application_id = 724
		and  profile_option_name = 'MSC_BOM_SUBST_PRIORITY');

Line: 1004

    update fnd_profile_option_values
    set profile_option_value = to_char(trans_attr1)
    where application_id = 723
    and level_id = 10001
    and profile_option_id = (select profile_option_id
		from fnd_profile_options
		where application_id = 723
		and  profile_option_name = 'MSO_TRSP_PENALTY');

Line: 1075

    update fnd_profile_option_values
    set profile_option_value = to_char(bom_attr1)
    where application_id = 724
    and level_id = 10001
    and profile_option_id = (select profile_option_id
		from fnd_profile_options
		where application_id = 724
		and  profile_option_name = 'MSC_ALT_BOM_COST');

Line: 1146

    update fnd_profile_option_values
    set profile_option_value = to_char(forecast_attr1)
    where application_id = 723
    and level_id = 10001
    and profile_option_id = (select profile_option_id
		from fnd_profile_options
		where application_id = 723
		and  profile_option_name = 'MSO_FCST_PENALTY');

Line: 1216

    update fnd_profile_option_values
    set profile_option_value = to_char(line_attr1)
    where application_id = 724
    and level_id = 10001
    and profile_option_id = (select profile_option_id
		from fnd_profile_options
		where application_id = 724
		and  profile_option_name = 'MSC_LINE_RES_GROUP');

Line: 1281

        update fnd_profile_option_values
           set profile_option_value = to_char(schedule_attr1)
           where application_id = 704
           and level_id = 10001
           and profile_option_id = (select profile_option_id
		from fnd_profile_options
		where application_id = 704
		and  profile_option_name = 'MRP_DMD_PRIORITY_FLEX_NUM');

Line: 1382

    errbuf := 'Created flexfields, updates profile values and submitted requests to recompile flexfields';

Line: 1480

        fnd_flex_dsc_api.delete_segment(
        appl_short_name => 'BOM',
        flexfield_name => 'SUB_OPERATION_RESOURCES',
        context => 'Global Data Elements',
        segment => 'Activity Grp Id - Alt Resource');

Line: 1601

	update fnd_profile_option_values
           set profile_option_value = to_char(bom_attr1)
           where application_id = 724
           and level_id = 10001
           and profile_option_id = (select profile_option_id
                from fnd_profile_options
                where application_id = 724
                and  profile_option_name = 'MSC_BATCHABLE_FLAG');

Line: 1662

      update fnd_profile_option_values
           set profile_option_value = to_char(bom_attr2)
           where application_id = 724
           and level_id = 10001
           and profile_option_id = (select profile_option_id
                from fnd_profile_options
                where application_id = 724
                and  profile_option_name = 'MSC_BATCHING_WINDOW');

Line: 1721

      update fnd_profile_option_values
           set profile_option_value = to_char(bom_attr3)
           where application_id = 724
           and level_id = 10001
           and profile_option_id = (select profile_option_id
                from fnd_profile_options
                where application_id = 724
                and  profile_option_name = 'MSC_MIN_CAPACITY');

Line: 1780

     update fnd_profile_option_values
           set profile_option_value = to_char(bom_attr4)
           where application_id = 724
           and level_id = 10001
           and profile_option_id = (select profile_option_id
                from fnd_profile_options
                where application_id = 724
                and  profile_option_name = 'MSC_MAX_CAPACITY');

Line: 1839

     update fnd_profile_option_values
           set profile_option_value = to_char(bom_attr5)
           where application_id = 724
           and level_id = 10001
           and profile_option_id = (select profile_option_id
                from fnd_profile_options
                where application_id = 724
                and  profile_option_name = 'MSC_UNIT_OF_MEASURE');

Line: 1950

    update fnd_profile_option_values
    set profile_option_value = to_char(fcst_attr1)
    where application_id = 724
    and level_id = 10001
    and profile_option_id = (select profile_option_id
                from fnd_profile_options
                where application_id = 724
                and  profile_option_name = 'MSC_FCST_PRIORITY_FLEX_NUM');