SYSTEM.AD_APPS_PRIVATE SQL Statements

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

Line: 26

  SELECT oracle_username
  INTO   l_apps_schema
  FROM   fnd_oracle_userid
  WHERE  read_only_flag='U';

Line: 31

  execute immediate 'select ' || l_apps_schema || '.ad_zd.get_edition(''' ||
                    x_edition_type || ''') from dual' into  l_edition;

Line: 48

    select u.editions_enabled
    into   l_enabled
    from   fnd_oracle_userid f,
           dba_users u
    where  f.read_only_flag='U'
    and    u.username=f.oracle_username;

Line: 55

    select editions_enabled
    into   l_enabled
    from   dba_users
    where  username=p_username;

Line: 91

   SELECT oracle_username
   INTO   l_apps_schema
   FROM   fnd_oracle_userid
   WHERE  read_only_flag='U';

Line: 96

   stmt := 'select ' ||l_apps_schema||'.AD_ZD_TABLE.EV_VIEW('''||p_obj_name||''') from DUAL';

Line: 111

      SELECT count(1)
      INTO  l_exist
      FROM  dba_editioning_views
      WHERE view_name=l_evname
      AND   owner=p_obj_owner;

Line: 332

    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: 376

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

Line: 434

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

Line: 448

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

Line: 499

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

Line: 557

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

Line: 675

    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: 719

      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: 793

     SELECT count(1)
     into   l_evexist
     FROM   dba_editioning_views
     WHERE  view_name=upper(l_evname)
     AND    table_name=upper(object_name)
     AND    owner=upper(target_schema);

Line: 994

    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: 1070

 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: 1203

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

Line: 1336

  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: 1359

  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: 1438

    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: 1446

    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: 1554

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

Line: 1562

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

Line: 1571

     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: 1781

    (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: 1798

    Select Nvl(Ev.View_Name,Tab.Table_Name) Target_name, Tab.table_name object_name, 'TABLE   ' object_type
    From Dba_Tables Tab
    Left Outer Join
    Dba_Editioning_Views Ev
    On (Tab.Table_Name=Ev.table_Name)
    Where Tab.Owner=Nvl(Ev.Owner, Tab.Owner)
    And   Tab.Owner=upper(base_schema)
    And   Tab.Iot_Name Is Null
    And   Tab.Table_Name Not Like '%$%'
    And Not Exists (Select 'x'
                    From  Dba_Queue_Tables Q
                    Where Owner=Tab.Owner
                    And   Queue_Table=Tab.Table_Name
                    And   Queue_table not like '%$%')
    And Not Exists (Select 'x'
                    From  Dba_Synonyms Syn
                    Where Syn.Owner=upper(apps_schema)
                    And   Syn.Table_Name=Nvl(Ev.View_Name,Tab.Table_Name)
                    And   Syn.Table_Owner=Tab.Owner)
    union all

    select sequence_name Target_name, 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 Target_name, 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: 1843

  SELECT oracle_username
  INTO   l_fnd_schema
  FROM   fnd_oracle_userid
  WHERE  read_only_flag='E';

Line: 1918

	Select decode (Computed_Value.Val,1,'TRUE','FALSE') into replace_existing_syn_tmp
    From (Select Count(1) as val
          From   Dba_Synonyms Ds
	      where  Ds.Table_Owner = upper(base_schema)
          And    Ds.Table_Name = rtrim(Syn_Rec.object_Name)) Computed_Value;

Line: 1933

        Select ds.synonym_name into syn_name
        From   dba_synonyms ds
        Where  ds.table_owner= upper(base_schema)
		And    ds.table_name = rtrim(Syn_Rec.object_Name);

Line: 1938

        Select rtrim(Syn_Rec.object_Name) into syn_name
        From dual;

Line: 2154

    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: 2246

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

Line: 2334

  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: 2357

          select_list           varchar2(20000);

Line: 2374

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

Line: 2405

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

Line: 2432

              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: 2440

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

Line: 2460

                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: 2469

                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: 2486

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

Line: 2548

                                        view_column_list,select_list);

Line: 2558

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

Line: 2625

    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: 2686

    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: 2716

    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: 2865

    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: 2875

    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: 2992

    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: 3162

        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: 3227

    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: 4003

    select oracle_username
    from fnd_oracle_userid
    where read_only_flag = 'K';

Line: 4020

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

Line: 4067

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

Line: 4223

  c_statement:='select count(1) ' ||
               'from dba_objects ' ||
               'where edition_name=:edition_name ' ||
               '  and owner=:schema_name ' ||
               '  and object_type=:object_type ' ||
               '  and object_name=:object_name';

Line: 4310

  SELECT oracle_username
  INTO   l_apps_schema
  FROM   fnd_oracle_userid
  WHERE  read_only_flag='U';

Line: 4314

  execute immediate 'select '||l_apps_schema||'.ad_zd.get_edition_type from dual'
     into l_edition_type;