APPS.AZ_FLEX_COMPILER SQL Statements

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

Line: 114

   SELECT fifs.id_flex_num
   FROM   fnd_application fa, fnd_id_flex_structures_vl fifs
   WHERE  fa.application_short_name = p_app_short_name
   AND    fa.application_id = fifs.application_id
   AND    fifs.id_flex_code = l_id_flex_code;

Line: 136

    	  l_debug_info := 'Select Key Flex: ' || p_app_short_name || ':' || p_flex_name;

Line: 137

    	  SELECT fif.id_flex_code
    	  INTO   l_id_flex_code
    	  FROM   fnd_application fa, fnd_id_flexs fif
    	  WHERE  fa.application_short_name = p_app_short_name
    	  AND    fa.application_id = fif.application_id
    	  AND    fif.id_flex_name = p_flex_name;

Line: 150

    	  l_debug_info := 'Select Descriptive Flex: ' || p_app_short_name || ':' || p_flex_name;

Line: 152

    	  select fdf.descriptive_flexfield_name
    	  into l_flex_name
    	  from fnd_application fa, fnd_descriptive_flexs_vl fdf
    	  where fa.application_short_name = p_app_short_name
    	  and fa.application_id = fdf.application_id
    	  and fdf.title = p_flex_name;

Line: 167

      l_debug_info := 'Select Flex Num: ' || p_app_short_name || ', code: ' || l_id_flex_code;

Line: 175

    	l_debug_info := 'Select Flex Num: ' || p_app_short_name || ', code: ' || l_id_flex_code;