APPS.GL_FLEXFIELDS_PKG SQL Statements

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

Line: 46

      SELECT fs.segment_name
      FROM   fnd_id_flex_segments fs,
             fnd_segment_attribute_values av
      WHERE  fs.application_column_name = av.application_column_name
      AND    av.id_flex_code = 'GL#'
      AND    fs.id_flex_code = av.id_flex_code
      AND    av.id_flex_num = coa_id
      AND    fs.application_id = 101
      AND    av.application_id = 101
      AND    fs.id_flex_num = av.id_flex_num
      AND    av.segment_attribute_type='GL_ACCOUNT'
      AND    av.attribute_value='Y';

Line: 151

    SELECT id_flex_structure_name
    INTO coa_name
    FROM fnd_id_flex_structures_vl
    WHERE application_id=101
    AND id_flex_code='GL#'
    AND id_flex_num=coa_id;

Line: 177

      SELECT segment_num, application_column_name
      FROM fnd_id_flex_segments
      WHERE application_id = 101
      AND   id_flex_code   = 'GL#'
      AND   enabled_flag   = 'Y'
      AND   id_flex_num    = x_chart_of_accounts_id
      ORDER BY segment_num;

Line: 344

            SELECT S.flex_value_set_id,
                   VS.validation_type
            INTO   v_vsid,
                   v_type
            FROM   FND_ID_FLEX_SEGMENTS S,
                   FND_FLEX_VALUE_SETS VS
            WHERE  S.id_flex_num = x_coa_id
            AND	   S.application_id = 101
            AND	   S.id_flex_code = 'GL#'
            AND	   S.segment_num = x_seg_num
            AND	   S.enabled_flag = 'Y'
            AND	   VS.flex_value_set_id = S.flex_value_set_id;

Line: 367

            SELECT application_table_name,
                   value_column_name,
                   meaning_column_name
            INTO   v_desc_table,
                   v_val_col,
                   v_desc_col
            FROM   FND_FLEX_VALIDATION_TABLES
            WHERE  flex_value_set_id = v_vsid;

Line: 390

            'SELECT	' || v_desc_col ||
            ' FROM	' || v_desc_table ||
            ' WHERE	' || v_val_col || ' = :seg_val ';

Line: 453

    SELECT validation_type
    INTO   val_type
    FROM   fnd_flex_value_sets
    WHERE  flex_value_set_id = x_value_set_id;

Line: 460

      SELECT application_table_name, value_column_name, summary_column_name
      INTO   val_table, val_col, sum_col
      FROM   fnd_flex_validation_tables
      WHERE  flex_value_set_id = x_value_set_id;

Line: 477

    stmt := 'SELECT ' || sum_col ||
            ' FROM ' || val_table ||
            ' WHERE ' || val_col || ' = :seg_val';

Line: 499

      SELECT min(parent_flex_value), count(*)
      FROM fnd_flex_value_norm_hierarchy
      WHERE flex_value_set_id = vs_id
      AND   child_flex_value_low = child_low
      AND   child_flex_value_high = child_high
      AND   range_attribute = 'C';

Line: 507

      SELECT parent_flex_value
      FROM fnd_flex_value_norm_hierarchy
      WHERE flex_value_set_id = vs_id
      AND   child_flex_value_low = child_low
      AND   child_flex_value_high = child_high
      AND   range_attribute = 'C'
      AND   (parent_flex_value, child_flex_value_low,
             child_flex_value_high) IN
               (SELECT parent_flex_value, child_flex_value_low,
                       child_flex_value_high
                FROM fnd_flex_value_norm_hierarchy
                START with     flex_value_set_id = vs_id
                           AND parent_flex_value = ancestor
                CONNECT BY     flex_value_set_id = vs_id
                AND parent_flex_value BETWEEN PRIOR child_flex_value_low
                                      AND PRIOR child_flex_value_high
                AND PRIOR range_attribute = 'P')
      ORDER BY parent_flex_value;