Query : To get all request with application

SELECT fa.application_short_name, fcpv.user_concurrent_program_name, 
description, 
DECODE (fcpv.execution_method_code, 
'B', 'Request Set Stage Function', 
'Q', 'SQL*Plus', 

'H', 'Host', 
'L', 'SQL*Loader', 
'A', 'Spawned', 
'I', 'PL/SQL Stored Procedure', 
'P', 'Oracle Reports', 
'S', 'Immediate', 
fcpv.execution_method_code 
) exe_method, 
output_file_type, program_type, printer_name, minimum_width, 
minimum_length, concurrent_program_name, concurrent_program_id 
FROM fnd_concurrent_programs_vl fcpv, fnd_application fa 
WHERE fcpv.application_id = fa.application_id 
ORDER BY description