Thursday, May 31, 2007

Display Module Wise Reports

Display Module Wise Reports

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 1


SELECT fa.application_short_name,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,COUNT (concurrent_program_id) COUNTFROM fnd_concurrent_programs_vl fcpv, fnd_application faWHERE fcpv.application_id = fa.application_idGROUP BY fa.application_short_name, fcpv.execution_method_codeORDER BY 1

No comments: