SYSTEM.AD_MLS SQL Statements

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

Line: 73

    statement := 'select install_group_num from '||upper(aol_schema)||
                 '.fnd_oracle_userid where read_only_flag = ''U'''||
                 ' order by install_group_num' ;

Line: 155

    statement := 'select language, attribute_column_name,    '||
       'translated_column_number from       '||
       aol_schema||'.ak_language_attribute_xrefs   '||
       'where language not in (select nls_language   '||
       'from '||aol_schema||'.fnd_languages      '||
       'where installed_flag = ''B'')         ';

Line: 206

            select_list      out nocopy varchar2)
is
  c         integer;

Line: 215

  lselect_list          varchar2(20000) := null;

Line: 225

      'select dtc.column_name,                                          '||
      '  decode(atc.column_name,'''',''N'',''Y'') mlsized,              '||
      '  translated_column_number                                       '||
      'from all_tab_columns dtc,                                        '||
      aol_schema||'.ak_translated_columns atc                           '||
      'where dtc.table_name = upper(:table_name)                        '||
      'and   nvl(atc.enabled_flag,''Y'') = ''Y''         '||
      'and   dtc.owner = upper(:table_owner)                            '||
      'and   atc.table_name (+) = dtc.table_name                        '||
      'and   atc.column_name (+) = dtc.column_name                      '||
      'order by dtc.column_id                                           ';

Line: 249

          lselect_list := lselect_list || ', ';

Line: 258

            lselect_list := lselect_list || ad_mls.mls_decode_1 ||
         '"'||column_name || '"), "' || column_name ||'")' ;

Line: 262

            lselect_list := lselect_list || ad_mls.mls_decode_2 ||
         '"'||column_name || '"), "' || column_name ||'")' ;

Line: 266

            lselect_list := lselect_list||'"'|| column_name||'"';

Line: 270

          lselect_list := lselect_list ||'"'|| column_name||'"';

Line: 281

    select_list := lselect_list;

Line: 288

      lview_column_list||','||lselect_list||
      '):'||ad_apps_private.error_buf;