application SN&name

SELECT DISTINCT
         A.APPLICATION_ID
       , A.application_short_name
       , b.application_name
       , c.RESPONSIBILITY_NAME
       , a.basepath
       , a.product_code
       , b.language
FROM
         fnd_application       a
       , fnd_application_tl    b
       , fnd_responsibility_Vl c
WHERE
         1                   =1
         AND a.application_id=b.application_id
         AND c.application_id=a.application_id
         AND B.LANGUAGE(+)   =USERENV('LANG')
         --AND b.application_name LIKE 'System Administra%'
         AND C.RESPONSIBILITY_NAME LIKE 'System Administra%'
         AND C.RESPONSIBILITY_KEY  LIKE 'System Administra%'
ORDER BY
         APPLICATION_ID
       , APPLICATION_SHORT_NAME
;