SELECT fa.application_short_name applshortname, fcpv.user_concurrent_program_name concprogramname, fav.application_name applicationname, fcpv.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, fnd_application_vl fav WHERE fcpv.application_id = fa.application_id and fa.application_id=fav.application_id and fa.application_short_name='PO' ORDER BY 1
No comments:
Post a Comment