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
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:
Post a Comment