Oracle EBS – Query profile e seus níveis

SELECT SUBSTR(e.profile_option_name, 1, 25) INTERNAL_NAME
      ,SUBSTR(pot.user_profile_option_name, 1, 60) NAME_IN_FORMS
      ,DECODE(a.level_id, 10001, 'Site', 10002, 'Application', 10003,
              'Resp', 10004, 'User', 10005, 'Server', 10007, 'Server+Resp',
              a.level_id) LEVELl
      ,DECODE(a.level_id, 10001, 'Site', 10002, c.application_short_name,
              10003, b.responsibility_name, 10004, d.user_name, 10005,
              n.node_name, 10007,
              m.node_name || ' + ' || b.responsibility_name, a.level_id) LEVEL_VALUE
      ,NVL(a.profile_option_value, 'Is Null') VALUE
      ,to_char(a.last_update_date, 'DD-MON-YYYY HH24:MI') LAST_UPDATE_DATE
      ,dd.USER_NAME LAST_UPDATE_USER
  FROM applsys.fnd_profile_option_values a
      ,applsys.fnd_responsibility_tl     b
      ,applsys.fnd_application           c
      ,applsys.fnd_user                  d
      ,applsys.fnd_profile_options       e
      ,applsys.fnd_nodes                 n
      ,applsys.fnd_nodes                 m
      ,applsys.fnd_responsibility_tl     x
      ,applsys.fnd_user                  dd
      ,applsys.fnd_profile_options_tl    pot
 WHERE e.profile_option_name = 'NOME DA PROFILE'
   AND e.PROFILE_OPTION_NAME = pot.profile_option_name(+)
   AND e.profile_option_id = a.profile_option_id(+)
   AND a.level_value = b.responsibility_id(+)
   AND a.level_value = c.application_id(+)
   AND a.level_value = d.user_id(+)
   AND a.level_value = n.node_id(+)
   AND a.LEVEL_VALUE_APPLICATION_ID = x.responsibility_id(+)
   AND a.level_value2 = m.node_id(+)
   AND a.LAST_UPDATED_BY = dd.USER_ID(+)
   AND pot.LANGUAGE = 'PTB' --US
 ORDER BY e.profile_option_name