Follow us: Subscribe via RSS Feed Connect on YouTube Connect on YouTube

Pages

Sunday, 5 February 2017

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

Share this article :

0 comments:

Post a Comment