Custom Application

  SELECT   a.APPLICATION_ID,
           a.APPLICATION_SHORT_NAME,
           c.APPLICATION_NAME,
           b.USER_NAME,
           a.CREATION_DATE
    FROM   fnd_application a, fnd_user b, fnd_application_tl c
   WHERE   a.application_id = c.application_id
           AND (a.created_by NOT IN (2, 1, -1, 0)
                OR a.LAST_UPDATE_LOGIN NOT IN (2, 1, -1, 0))
           AND b.user_id(+) = a.created_by
           AND b.user_id(+) = a.last_updated_by
ORDER BY   a.CREATION_DATE DESC