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