SYSTEM.AD_APPS_PRIVATE SQL Statements

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

Line: 172

    select count(*)
    into dummy
    from dba_objects
    where object_type in ('PACKAGE', 'PACKAGE BODY')
    and object_name in ('APPS_DDL', 'APPS_ARRAY_DDL')
    and status = 'VALID'
    and owner = upper(schema_name);

Line: 216

    select name from sys.user$
    where name = upper(check_if_schema_exists.schema_name);

Line: 274

     SELECT object_type
       INTO l_object_type
       FROM dba_objects
       WHERE owner = p_grantor_schema_name
       AND object_name = p_object_name;

Line: 288

   SELECT table_owner
   INTO l_owner_schema_name
   FROM dba_synonyms
   WHERE owner = p_grantor_schema_name
   AND synonym_name = p_object_name;

Line: 339

	SELECT 1, owner into l_exists, l_queue_owner
        FROM dba_queues where name = p_object_name;

Line: 394

     SELECT object_type
       INTO l_object_type
       FROM dba_objects
       WHERE owner = p_to_schema_name
       AND object_name = p_to_object_name;

Line: 508

    c_statement:= 'select oracle_username from '||
                  aol_or_apps_schema||'.fnd_oracle_userid '||
                  'where (install_group_num = :install_group_num '||
                  '      or install_group_num = '||
                  '           (select min(install_group_num) from '||
                  aol_or_apps_schema||'.fnd_oracle_userid '||
                  '     where 1 = decode (:install_group_num,0,1,2) '||
                  '     and read_only_flag = ''U'')) '||
                  'and read_only_flag = ''U'' ';

Line: 552

      c_statement:= 'select oracle_username from '||
                  aol_or_apps_schema||'.fnd_oracle_userid '||
                  'where (install_group_num = :install_group_num '||
                  '      or install_group_num = '||
                  '           (select min(install_group_num) from '||
                  aol_or_apps_schema||'.fnd_oracle_userid '||
                  '     where 1 = decode (:install_group_num,0,1,2) '||
                  '     and read_only_flag = ''M'')) '||
                  'and read_only_flag = ''M'' ';

Line: 782

    select text into view_text from dba_views
    where owner = upper(copy_view_internal.from_schema)
    and   view_name = copy_view_internal.view_name;

Line: 858

 select dv.text_length
 into view_size
 from dba_views dv
 where dv.view_name= copy_view_internal.view_name
 and   dv.owner= upper(copy_view_internal.from_schema);

Line: 991

  statement := 'select text into :view_text from dba_views '||
    'where owner='''||copy_huge_view.fromschema||''' '||
    'and view_name='''||copy_huge_view.view_name||'''';

Line: 1124

  statement1 := 'select text into :view_text from dba_views '||
  'where owner=upper('''||fromschema||''') '||
  'and view_name=upper('''||view_name||''') '||
  'and text_length='||from_len;

Line: 1147

  statement2 := 'select text into :view_text from dba_views '||
  'where owner=upper('''||toschema||''') '||
  'and view_name=upper('''||view_name||''') '||
  'and text_length='||to_len;

Line: 1226

    select text from dba_source
    where owner = upper(copy_code.from_schema)
    and name = copy_code.object_name
    and type = copy_code.object_type
    order by line;

Line: 1234

    select
       substr(s.text, instr(s.text,'$Header'||': '),
              ((instr(s.text,' $', instr(s.text,'$Header'||': ')) + 2)
               - instr(s.text,'$Header'||': ')))
    from dba_source s
    where s.owner= upper(c_owner)
    and   s.name = upper(c_name)
    and   s.type = upper(c_type)
    and   s.line between 2 and 5
    and   s.text like '%$Header'||': % $%';

Line: 1342

    select count(*)
    from dba_source
    where owner = upper(c_owner)
    and   name  = upper(c_name)
    and   type  = upper(c_type);

Line: 1350

    select count(*), sum(length(text))
    from dba_source
    where owner = upper(c_owner)
    and   name  = upper(c_name)
    and   type  = upper(c_type);

Line: 1359

     SELECT /*+FIRST_ROWS */
         'X'
     FROM
        dba_source ds1,
        dba_source ds2
     WHERE
           ds1.owner = UPPER(s_owner)
     AND   ds1.name  = UPPER(c_name )
     AND   ds1.type  = UPPER(c_type )
     AND   ds2.owner = UPPER(d_owner)
     AND   ds2.name  = UPPER(c_name )
     AND   ds2.type  = UPPER(c_type )
     AND  (ds1.line <> ds2.line
     OR    ds1.text <> ds2.text     )
     AND   rownum =1;

Line: 1569

    (select table_name object_name, 'TABLE   ' object_type
     from dba_tables
     where owner= upper(base_schema)
     and   iot_name is null
     and   table_name not like '%$%'
     minus
     select queue_table object_name, 'TABLE   ' object_type
     from dba_queue_tables
     where owner= upper(base_schema)
     and   queue_table not like '%$%')
    union all
    select sequence_name object_name, 'SEQUENCE' object_type
    from dba_sequences
    where sequence_owner= upper(base_schema)
    and sequence_name not like '%$%';

Line: 1586

    (select table_name object_name, 'TABLE   ' object_type
     from dba_tables dt
     where owner= upper(base_schema)
     and   iot_name is null
     and   table_name not like '%$%'
     minus
     select queue_table object_name, 'TABLE   ' object_type
     from dba_queue_tables
     where owner= upper(base_schema)
     and   queue_table not like '%$%')
    minus
    select ds.synonym_name object_name, 'TABLE   ' object_type
    from dba_synonyms ds
    where ds.owner = upper(apps_schema)
    and   ds.table_owner  = upper(base_schema)
    and   ds.synonym_name = ds.table_name
    and   ds.table_name not like '%$%'
    union all
    select sequence_name object_name, 'SEQUENCE' object_type
    from dba_sequences seq
    where sequence_owner= upper(base_schema)
    and sequence_name not like '%$%'
    minus
    select ds.synonym_name object_name, 'SEQUENCE' object_type
    from dba_synonyms ds
    where ds.owner = upper(apps_schema)
    and   ds.table_owner  = upper(base_schema)
    and   ds.synonym_name = ds.table_name
    and   ds.table_name not like '%$%';

Line: 1874

    select ds.synonym_name
    from dba_synonyms ds
    where ds.owner = upper(from_schema)
    and   ds.synonym_name = ds.table_name -- regular synonyms only
    and   ds.synonym_name not like '%$%';

Line: 1966

    select ds.synonym_name
    from dba_synonyms ds
    where ds.owner = upper(fromschema)
    and   ds.synonym_name <> ds.table_name; -- odd synonyms only

Line: 2054

  oracle_id_sql constant varchar2(2000) := ign_schema_select_part1||
          aol_schema||ign_schema_select_part2||aol_schema||
          ign_schema_select_part3||' in (to_char(:install_g_num), 0 )';

Line: 2077

          select_list           varchar2(20000);

Line: 2094

                        'select nvl(max(last_update_date),              '||
                        '    to_date(''01/01/1970'',''DD/MM/YYYY''))    '||
                        '    from '||aol_schema||'.ak_translated_columns';

Line: 2125

                        'select nvl(max(last_update_date),              '||
                        '   to_date(''01/01/1970'',''DD/MM/YYYY''))     '||
                        '   from '||aol_schema||'.ak_language_attribute_xrefs';

Line: 2152

              statement := 'select distinct upper(atc.table_name)           '||
                           'from '||aol_schema||'.ak_translated_columns atc,'||
                           '     dba_tables dt                              '||
                           'where dt.table_name = upper(atc.table_name)     '||
                           'and nvl(atc.enabled_flag,''Y'') = ''Y''         '||
                           'and dt.owner = :table_schema                    ';

Line: 2160

              statement := 'select null from sys.dual where 1 = 2   '||
                           'and :table_schema = ''X''                       ';

Line: 2180

                select nvl(min(last_ddl_time),
                        to_date('01/01/1970','DD/MM/YYYY'))
                into view_date
                from dba_objects
                where object_name = upper(l_table_name)
                and object_type = 'VIEW'
                and owner = upper(apps_schema);

Line: 2189

                select nvl(min(decode(last_ddl_time,sysdate,
                        to_date('31/12/2199','DD/MM/YYYY'),last_ddl_time)),
                        to_date('01/01/1970','DD/MM/YYYY'))
                into table_date
                from dba_objects
                where object_name = upper(l_table_name)
                and object_type = 'TABLE'
                and owner = upper(table_schema);

Line: 2206

                          'select last_update_date                          '||
                          ' from '||aol_schema||'.ak_translated_columns     '||
                          ' where upper(table_name) = upper(:table_name)    ';

Line: 2268

                                        view_column_list,select_list);

Line: 2278

                               ' as select ' || select_list || ' from '||
                               table_schema||'."'||l_table_name||'"';

Line: 2345

    select v1.view_name, v1.text_length source_len,
           v2.text_length dest_len
    from dba_views v1, dba_views v2
    where v1.owner = upper(fromschema)
    and   v1.view_name not like 'AI9%'
    and   v1.view_name not like 'AI1%'
    and   v2.owner (+) = upper(toschema)
    and   v2.view_name (+) = v1.view_name;

Line: 2406

    select do.object_name, do.object_type, do2.object_name name2
    from dba_objects do, dba_objects do2
    where do.owner = upper(copy_stored_progs.fromschema)
    and   do.object_type in (
     decode(copy_stored_progs.p_object_type,
                        'B',null,          'P',null,          'F',null,
                        'C',null,          'A','PACKAGE',     'S','PACKAGE',
                        'PACKAGE'),
     decode(copy_stored_progs.p_object_type,
                        'B','PACKAGE BODY','P',null,          'F',null,
                        'C','PACKAGE BODY','A','PACKAGE BODY','S',null,
                        'PACKAGE BODY'),
     decode(copy_stored_progs.p_object_type,
                        'B',null,          'P',null,          'F','FUNCTION',
                        'C','FUNCTION',    'A','FUNCTION',    'S',null,
                        'FUNCTION'),
     decode(copy_stored_progs.p_object_type,
                        'B',null,          'P','PROCEDURE',   'F',null,
                        'C','PROCEDURE',   'A','PROCEDURE',   'S',null,
                        'PROCEDURE'))
    and   do.object_name not in ('APPS_DDL', 'APPS_ARRAY_DDL')
    and   do.object_name not like 'FFP%'
    and   do.object_name like copy_stored_progs.p_subset || '%'
    and   do2.owner (+) = upper(copy_stored_progs.toschema)
    and   do2.object_name (+) = do.object_name
    and   do2.object_type (+) = do.object_type
    order by decode(do.object_type,'PACKAGE',1,2);

Line: 2436

    select
       substr(s.text, instr(s.text,'$Header'||': '),
              ((instr(s.text,' $', instr(s.text,'$Header'||': ')) + 2)
               - instr(s.text,'$Header'||': ')))
    from dba_source s
    where s.owner= upper(c_owner)
    and   s.name = upper(c_name)
    and   s.type = upper(c_type)
    and   s.line between 2 and 5
    and   s.text like '%$Header'||': % $%';

Line: 2585

    select 'X'
    from dba_synonyms
    where owner = c_owner
    and   synonym_name = c_synonym_name
    and   table_owner = c_table_owner
    and   table_name = c_table_name
    and   db_link is null;

Line: 2595

    select object_type
    from dba_objects
    where owner = c_owner
    and   object_name = c_object_name
    order by decode(object_type, 'PACKAGE', 1, 2);

Line: 2712

    select distinct c_level, referenced_name, referenced_type
    from dba_dependencies
    where owner = c_owner
    and   name  = c_name
    and   type  = c_type
    and   referenced_owner = owner
    and   referenced_type in
            ('VIEW', 'PACKAGE', 'PROCDEDURE', 'FUNCTION', 'PACKAGE BODY');

Line: 2882

        select object_name
        into dummy
        from dba_objects
        where owner = recompile_schema
        and   object_name = obj_names(i)
        and   object_type = obj_types(i);

Line: 2947

    select column_name from dba_tab_columns
    where table_name = build_view_columns.view_name
    and   owner = upper(build_view_columns.from_schema)
    order by column_id;

Line: 3723

    select oracle_username
    from fnd_oracle_userid
    where read_only_flag = 'K';

Line: 3740

      statement := 'select nvl(min(multi_currency_flag),''N''), '||
                'nvl(min(multi_lingual_flag),''N'') '||
                'from '||aol_schema||'.fnd_product_groups';

Line: 3787

                l_statement := 'select release_name from ' || aol_schema ||
                               '.fnd_product_groups';