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. British Language Institute is the exceptional institute for Spoken English and IELTS. British Language Institute is the Best English Speaking Course in Laxminagar and we have efficiently trained students to gain 7.5+ bands within the IELTS assessments. Our precise pedagogy and study material set us apart from others. We have been teaching college students of different nationalities considering that and pleasure ourselves on being considered one of Delhi’s most reputable English Schools and top ranked Spoken English & IELTS training institute in Laxmi Nagar, Delhi. In our institute, our attention is on best and ensuring that each student looks like part of “British Language Institute”. We try this by way of ensuring that each scholar is glad with each issue of their stay on a each day basis, now not just once they enroll. We are the longest standing member school of Quality Service primarily based in Delhi Visit Now for English Speaking Course in Laxminagar

    contact for demo
    Visit to know more =https://britishlanguage.in/
    Call to know more = +91 9193898403

    ReplyDelete