APPS.FND_VSET SQL Statements

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

Line: 9

     SELECT /* $Header: AFFFVDUB.pls 120.3.12010000.1 2008/07/25 14:14:50 appldev ship $ */
       flex_value,
       flex_value, description,
       start_date_active, end_date_active,
       parent_flex_value_low
       FROM fnd_flex_values_vl
       WHERE flex_value_set_id = valueset.vsid
       AND enabled_flag = enabled
       ORDER BY 1;

Line: 24

     SELECT /* $Header: AFFFVDUB.pls 120.3.12010000.1 2008/07/25 14:14:50 appldev ship $ */
       flex_value,
       flex_value_meaning, description,
       start_date_active, end_date_active,
       parent_flex_value_low
       FROM fnd_flex_values_vl
       WHERE flex_value_set_id = valueset.vsid
       AND enabled_flag = enabled
       ORDER BY 1;

Line: 105

   SELECT /* $Header: AFFFVDUB.pls 120.3.12010000.1 2008/07/25 14:14:50 appldev ship $ */
     flex_value_set_id, flex_value_set_name,
     validation_type
     INTO vset.vsid, vset.name, vset.validation_type
     FROM fnd_flex_value_sets
     WHERE flex_value_set_id = valueset_id;

Line: 112

   SELECT /* $Header: AFFFVDUB.pls 120.3.12010000.1 2008/07/25 14:14:50 appldev ship $ */
     format_type, alphanumeric_allowed_flag,
     uppercase_only_flag, numeric_mode_enabled_flag,
     maximum_size, maximum_value, minimum_value,
     longlist_flag
     INTO fmt.format_type, fmt.alphanumeric_allowed_flag,
     fmt.uppercase_only_flag, fmt.numeric_mode_flag,
     fmt.max_size, fmt.max_value, fmt.min_value,
     fmt.longlist_flag
     FROM fnd_flex_value_sets
     WHERE flex_value_set_id = valueset_id;

Line: 127

      SELECT /* $Header: AFFFVDUB.pls 120.3.12010000.1 2008/07/25 14:14:50 appldev ship $ */
	application_table_name, id_column_name, id_column_type,
	value_column_name, meaning_column_name,
	additional_where_clause,
	start_date_column_name, end_date_column_name
	INTO table_info
	FROM fnd_flex_validation_tables
	WHERE flex_value_set_id = vset.vsid;

Line: 156

     /* these are from the tables - should really be doing a select */
     max_id_size NUMBER; -- := 150;

Line: 199

   sqlstring := 'select ' || cols ||
     ' from ' || table_info.table_name ||
     '  ' || table_info.where_clause;