Query To find out details of concurrent request submitted with certain conditions

The relevant query is as follows:

Select request_id, req.CONCURRENT_PROGRAM_ID, prog.DESCRIPTION, Request_date, printer, number_of_copies, usr.user_name 

from fnd_concurrent_requests req,  fnd_concurrent_programs_tl prog, fnd_user usr

where printer <> 'noprint'

and requested_start_date > '14-AUG-06'

and status_code = 'C'

and number_of_copies > 0

and prog.CONCURRENT_PROGRAM_ID = req.CONCURRENT_PROGRAM_ID

and prog.language = 'US'

and req.requested_by = usr.user_id

order by request_date desc