ERPstuff - Oracle EBS Community

-- Query for Concurrent Manager Programs

SELECT fnd.application_name,
fnd_concurrent_programs_tl.user_concurrent_program_name,
fnd_concurrent_programs_tl.description
FROM applsys.fnd_application_tl fnd, applsys.fnd_concurrent_programs_tl
WHERE ((fnd.application_id = fnd_concurrent_programs_tl.application_id))
ORDER BY fnd.application_name ASC,
fnd_concurrent_programs_tl.user_concurrent_program_name ASC