My Oracle HRMS Experiences!

Wednesday, September 26, 2007

Important SQL Queries

5:16 AM Posted by Mohammed Abdur Rahman No comments
The following queries are very important to have a first hand knowledge of Oracle Applications.

Details of concurrent program submitted
SELECT fcr.* FROM apps.fnd_concurrent_requests fcr ,apps.fnd_concurrent_programs_vl fcpv
WHERE fcr.concurrent_program_id=fcpv.concurrent_program_id AND fcpv.user_concurrent_program_name='Security List Maintenance'
AND TRUNC(fcr.requested_start_date) >= '01-MAR-2011' ORDER BY fcr.requested_start_date DESC

0 comments: