R12_profile_options_query

  SELECT   B.APPLICATION_ID,
           a.APPLICATION_NAME,
           d.APPLICATION_SHORT_NAME,
           b.PROFILE_OPTION_ID,
           b.PROFILE_OPTION_NAME,
           T.USER_PROFILE_OPTION_NAME,
           d.BASEPATH,
           T.DESCRIPTION
    FROM   FND_PROFILE_OPTIONS_TL T, FND_PROFILE_OPTIONS B,fnd_application_tl a,fnd_application D
   WHERE   B.PROFILE_OPTION_NAME = T.PROFILE_OPTION_NAME
   AND     a.APPLICATION_ID = b.APPLICATION_ID
   AND     a.APPLICATION_ID = d.APPLICATION_ID
ORDER BY   application_id