APPS.HXC_VTL_SHD SQL Statements

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

Line: 48

    select
       alias_value_id
      ,alias_value_name
      ,language
      ,source_lang
    from  hxc_alias_values_tl
    where alias_value_id = p_alias_value_id
    and   language = p_language;

Line: 114

    select
       alias_value_id
      ,alias_value_name
      ,language
      ,source_lang
    from	hxc_alias_values_tl
    where	alias_value_id = p_alias_value_id
    and   language = p_language
    for	update nowait;

Line: 190

  delete from hxc_alias_values_tl t
   where not exists
      (select null
         from hxc_alias_values_tl b
        where b.alias_value_id = t.alias_value_id
      );

Line: 197

  update hxc_alias_values_tl t
  set (alias_value_name) =
      (select b.alias_value_name
         from hxc_alias_values_tl b
        where b.alias_value_id = t.alias_value_id
          and b.language = t.source_lang)
  where (t.alias_value_id
        ,t.language)
     in (select subt.alias_value_id
               ,subt.language
           from hxc_alias_values_tl subb
               ,hxc_alias_values_tl subt
          where subb.alias_value_id = subt.alias_value_id
            and subb.language = subt.source_lang
            and subb.alias_value_name <> subt.alias_value_name
        );

Line: 214

  insert into hxc_alias_values_tl
   (alias_value_id
   ,alias_value_name
   ,language
   ,source_lang
   ,last_update_date
   ,last_updated_by
   ,last_update_login
   ,created_by
   ,creation_date
   )
   select b.alias_value_id
         ,b.alias_value_name
         ,l.language_code
         ,b.source_lang
         ,b.last_update_date
         ,b.last_updated_by
         ,b.last_update_login
         ,b.created_by
         ,b.creation_date
    from hxc_alias_values_tl b
        ,fnd_languages l
   where l.installed_flag in ('I', 'B')
     and b.language = userenv('LANG')
     and not exists
        (select null
           from hxc_alias_values_tl t
          where t.alias_value_id = b.alias_value_id
            and t.language = l.language_code
        );