APPS.FLM_UTIL SQL Statements

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

Line: 18

  SELECT concatenated_segments
  INTO l_result
  FROM mtl_categories_kfv
  WHERE category_id = cat_id;

Line: 31

  SELECT concatenated_segments
  INTO l_result
  FROM mtl_system_items_kfv
  WHERE inventory_item_id = item_id
    AND organization_id = org_id;

Line: 45

  SELECT concatenated_segments
  INTO l_result
  FROM mtl_item_locations_kfv
  WHERE inventory_location_id = loc_id
    AND organization_id = org_id;

Line: 276

  g_bind_table.DELETE;

Line: 393

SELECT  fs.application_column_name,
        vs.format_type
FROM    FND_FLEX_VALUE_SETS vs,
        FND_ID_FLEX_SEGMENTS_VL fs
WHERE   fs.application_id = 401
AND     fs.id_flex_code   = 'MCAT'
AND     fs.id_flex_num    = l_struct_num
AND     fs.enabled_flag   = 'Y'
AND     fs.display_flag   = 'Y'
AND     vs.flex_value_set_id = fs.flex_value_set_id
ORDER BY
        fs.segment_num;

Line: 408

  SELECT id_flex_num
  INTO   l_flex_num
  FROM   fnd_id_flex_structures fs
  WHERE  fs.id_flex_code = 'MCAT'
  AND    fs.id_flex_num = p_cat_struct_id;

Line: 506

SELECT  fs.application_column_name,
        vs.format_type
FROM    FND_FLEX_VALUE_SETS vs,
        FND_ID_FLEX_SEGMENTS_VL fs
WHERE   fs.application_id = 401
AND     fs.id_flex_code   = 'MSTK'
AND     fs.id_flex_num    = l_struct_num
AND     fs.enabled_flag   = 'Y'
AND     fs.display_flag   = 'Y'
AND     vs.flex_value_set_id = fs.flex_value_set_id
ORDER BY
        fs.segment_num;

Line: 521

  SELECT id_flex_num
  INTO   l_flex_num
  FROM   fnd_id_flex_structures
  WHERE  id_flex_code = 'MSTK';

Line: 526

  SELECT  count(*)
  INTO    l_no_of_segs
  FROM    FND_ID_FLEX_SEGMENTS_VL fs
  WHERE   fs.application_id = 401
  AND     fs.id_flex_code   = 'MSTK'
  AND     fs.id_flex_num    = l_flex_num
  AND     fs.enabled_flag   = 'Y'
  AND     fs.display_flag   = 'Y';