1 Reply Latest reply on Aug 9, 2018 2:21 PM by John_K

    Establishing an Hierarchical order of all those applications

    LPNO

      With SQL

       

      SELECT 
         fa.basepath
         ,fa.product_code
         ,fa.application_id
         ,fa.application_short_name
         ,fat.application_name
         ,fa.application_id
         ,fpi.patch_level
         ,decode(fpi.STATUS,'I','Licensed', 'N','Not Licensed','S','Shared','Undetermined') STATUS
        FROM fnd_product_installations fpi
            ,fnd_application fa
            ,fnd_application_tl fat
       WHERE fa.application_id = fpi.application_id(+) 
         AND fat.application_id = fa.application_id
         AND fat.LANGUAGE = USERENV ('LANG')
         and decode(fpi.STATUS,'I','Licensed', 'N','Not Licensed','S','Shared','Undetermined')  <> 'Not Licensed';
      
      

       

      I can get a neat list of all applications.used/licensed in our OEBS.

       

      The list is quite detailled, thus I miss some grouping attributes. Some Applications are base technology, some belong to specific business functions like finance, sales, production, Scm.

       

      Does OEBS offer some means to reorganize these applications into some structured tree-like overview grouping those applications into more general subjects?

      If not can you provide a custom table doing such groupings take make broader sense?