APPS.PQP_OSS_DFF_UTILS SQL Statements

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

Line: 18

  SELECT flex_value_set_name
    FROM fnd_flex_value_sets
   WHERE flex_value_set_id = c_val_set_id;

Line: 61

  SELECT concatenated_segment_delimiter, context_column_name
    FROM fnd_descriptive_flexs
   WHERE descriptive_flexfield_name IN (c_ddf_name)
     AND application_id = c_app_id;

Line: 70

  SELECT application_column_name, flex_value_set_id
    FROM fnd_descr_flex_column_usages
   WHERE descriptive_flexfield_name = c_ddf_name
     AND descriptive_flex_context_code IN ('Global Data Elements', c_context_value)
     AND enabled_flag = 'Y'
     AND display_flag = 'Y'
     AND application_id = c_app_id
   ORDER BY descriptive_flex_context_code, column_seq_num;

Line: 120

  l_dyn_sql_qry := 'SELECT P_'            || l_delim_ctx_rec.con_col_name ||
                   '  FROM '              || p_dp_view_name               ||
             	   ' WHERE batch_id = '   || p_batch_id;

Line: 166

     l_dyn_sql_qry         := 'SELECT ''' || l_dff_ctx_val || l_delimiter ||
                              '''|| '     || parse_segment(l_seg_val_rec);

Line: 172

     l_dyn_sql_qry := 'SELECT ' || parse_segment(l_seg_val_rec);

Line: 238

     SELECT substr(application_column_name,8,2)
     FROM   fnd_id_flex_segments_vl
     WHERE  id_flex_code = c_id_flex_code
     AND    id_flex_num  = c_keyflex_structure
     AND    enabled_flag = 'Y'
     AND    display_flag = 'Y'
     ORDER BY segment_num;