Follow us: Connect on YouTube 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 :

3 comments:

  1. Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check https://www.oracleappstechnical.com for Never Before Offers and Discount Coupon Codes.

    ReplyDelete
  2. Coaching service of ielts, oat, english speaking, study abroad consultancy is provided by Cambridge English Academy in the name of noida, delhi, laxmi nagar etc. in which you are also given study material, notes and extra classes along with the course. You do not even have to pay extra fees. In Spoken english classes in noida, you get the facility of online and offline classes in which highly educated and very professional teachers teach you so that you can fulfill your dream of knowing Abroad and create a secure future for yourself. To know or for Demo contact -
    to take a demo
    Website - https://cambridgeenglish.org.in/
    for call - 9667728146

    ReplyDelete
  3. Vcare Technical Institute has been providing students with a rich and diverse learning environment. Our unparalleled teaching methods help to launch students into the successful future they have always dreamed of. Vcare Technical Institute is located in Laxmi Nagar, Delhi and has over 100 students and a renowned staff. We encourage both staff and students alike to grow, learn and create each passing day.

    We are Provided Various Computer Courses Such as Computer Basic With Advanced, Core java, Advance java, Core PHP, Advance PHP++, Photoshop, Computer Typing and Other Courses. A Computer Course Overview Windows 7 overview, MS Word, MS Excel, MS Power Point, MS Publisher, MS Picture Manager, MS Outlook, MS Access, Basic HTML,
    C++ training laxmi nagar Coding classes in Laxminagar , Internet- Search Engines, Email – Account creation, sending and receiving emails, Printing, Scanning, using external Media etc. Excel – creating spreadsheet, Applying formula, pivot table, H lookup, V lookup, filter, freeze, sorting, logical function.

    ReplyDelete