SELECT request_id, user_name, FND_DATE.date_to_chardt(request_date,2) request_date, ret_trans_code from hxc_retrieval_requests_all ret, FND_user fu WHERE ret.user_id = fu.user_id
View Text - HTML Formatted
SELECT REQUEST_ID , USER_NAME , FND_DATE.DATE_TO_CHARDT(REQUEST_DATE , 2) REQUEST_DATE , RET_TRANS_CODE FROM HXC_RETRIEVAL_REQUESTS_ALL RET , FND_USER FU WHERE RET.USER_ID = FU.USER_ID