select appid, appName, appType, uri, parameters from tbl_STP_Applications where apptype = and appid = order by appName;