SELECT
	regist_no,
	regist_date,
	org_name,
	item_type_name,
	loss_type_name,
	loss_name,
	case_item_type_name,
	app_inflow_time,
	app_inflow_type,
	reassign_source_name,
	app_outflow_time,
	app_outflow_type_name,
	app_handle_type_name,
	app_handle_name,
	app_handle_username,
	app_handle_mobile,
	app_handle_usercode,
	app_handle_org_name
FROM
	report_item_process
ORDER BY
	regist_date_value DESC,
	loss_id ASC,
	app_inflow_time_value DESC