APPS.FND_UMS_ANALYSIS_ENGINE SQL Statements

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

Line: 740

         select 'AFUMSAEB.pls : $Revision: 120.1 $ : create_bugfix' arcs_revision,
                bugfix_guid,
                release_name,
                bug_number,
                download_mode,
                application_short_name,
                release_status,
                type,
                abstract
           into g_arcs_revision,
                l_bugfix.bugfix_guid,
                l_bugfix.release_name,
                l_bugfix.bug_number,
                l_bugfix.download_mode,
                l_bugfix.application_short_name,
                l_bugfix.release_status,
                l_bugfix.type,
                l_bugfix.abstract
           from fnd_ums_bugfixes
          where release_name = p_release_name
            and bug_number = p_bug_number
            and download_mode <> fnd_ums_loader.DL_MODE_NONE;

Line: 933

         select 'AFUMSAEB.pls : $Revision: 120.1 $ : get_bugfix' arcs_revision,
                release_name,
                bug_number
           into g_arcs_revision,
                l_release_name,
                l_bug_number
           from fnd_ums_bugfixes
          where bugfix_guid = p_bugfix_guid;

Line: 1026

      select 'AFUMSAEB.pls : $Revision: 120.1 $ : get_replacement_bugfix_guid' arcs_revision,
             related_bugfix_guid
        into g_arcs_revision,
             l_replacement_bugfix_guid
        from fnd_ums_bugfix_relationships
       where bugfix_guid = p_bugfix_guid
         and relation_type = fnd_ums_loader.REL_TYPE_REPLACED_BY;

Line: 1249

      select 'AFUMSAEB.pls : $Revision: 120.1 $ : check_bugfix_prereqs' arcs_revision,
             fubr.related_bugfix_guid,
             fubr.relation_type
        from fnd_ums_bugfix_relationships fubr,
             fnd_ums_bugfixes fub
       where fubr.bugfix_guid = p_bugfix_guid
        --
        -- - Direct/Indirect Prereq links are followed
        --
        --   fubr.related_bugfix
        --    /|\
        --     |
        --     |P/P'
        --     |
        --     |
        --   fubr.bugfix
        --
         and fubr.relation_type in (fnd_ums_loader.REL_TYPE_PREREQS,
                                    fnd_ums_loader.REL_TYPE_INDIRECTLY_PREREQS)
         and fub.bugfix_guid = fubr.related_bugfix_guid
       order by decode(fubr.relation_type,
                       fnd_ums_loader.REL_TYPE_INDIRECTLY_PREREQS,  1,
                       fnd_ums_loader.REL_TYPE_PREREQS,             2,
                       99),
                fub.bug_number;

Line: 1360

      select alias_bugfix_guid,
             alias_relation_type
        from (select fubr.related_bugfix_guid alias_bugfix_guid,
                     fubr.relation_type alias_relation_type
                from fnd_ums_bugfix_relationships fubr
               where fubr.bugfix_guid = p_bugfix_guid
                 and fubr.relation_type = fnd_ums_loader.REL_TYPE_REPLACED_BY
              union
              select fubr.bugfix_guid alias_bugfix_guid,
                     fubr.relation_type alias_relation_type
                from fnd_ums_bugfix_relationships fubr
               where fubr.related_bugfix_guid = p_bugfix_guid
                 and fubr.relation_type in (fnd_ums_loader.REL_TYPE_INCLUDES,
                                            fnd_ums_loader.REL_TYPE_INDIRECTLY_INCLUDES)) rels,
             fnd_ums_bugfixes fub
       where 'AFUMSAEB.pls : $Revision: 120.1 $ : get_equivalency_result' is not null
         and rels.alias_bugfix_guid = fub.bugfix_guid
       order by decode(alias_relation_type,
                       fnd_ums_loader.REL_TYPE_REPLACED_BY, 1,
                       fnd_ums_loader.REL_TYPE_INDIRECTLY_INCLUDES, 2,
                       fnd_ums_loader.REL_TYPE_INCLUDES, 3,
                       99),
                fub.bug_number;

Line: 2112

         select 'AFUMSAEB.pls : $Revision: 120.1 $ : init_globals' arcs_revision,
                name, applications_system_name
           into g_arcs_revision,
                l_appl_top_name, l_applications_system_name
           from ad_appl_tops
          where appl_top_id = p_appl_top_id;