Master OracleApps

Query to find Concurrent Program related information.

-------------------------------------------------------------------------------

-- Query to find Concurrent Program related information

-------------------------------------------------------------------------------

SELECT cpv.user_concurrent_program_name "Concurrent Program Name",

cpv.concurrent_program_name "Program Short Name",

efv.application_name "Application",

cpv.enabled_flag "Enabled Flag",

-- cpv.description "Description",

cpv.output_file_type "Output Format",

fu.user_name "Created By (userid)",

-- ppf.full_name "Created By (username)",

DECODE(efv.execution_method_code,

'I', 'PL/SQL Stored Procedure',

'H', 'Host',

'S', 'Immediate',

'J', 'Java Stored Procedure',

'K', 'Java Concurrent Program',

'M', 'Multi Language Function',

'P', 'Oracle Reports',

'B', 'Request Set Stage Function',

'A', 'Spawned',

'L', 'SQL*Loader',

'Q', 'SQL*Plus',

'E', 'Pearl Concurrent Programm',

'Unknown') "Execution Method",

efv.executable_name "Executable Name",

efv.execution_file_name "Execution Filename"

FROM fnd_executables_form_v efv,

fnd_concurrent_programs_vl cpv,

fnd_user fu

-- per_all_people_f ppf

WHERE efv.executable_id = cpv.executable_id

AND efv.application_id = cpv.application_id

AND cpv.created_by = fu.user_id

-- AND fu.employee_id = ppf.person_id

AND cpv.user_concurrent_program_name = 'TAMS SMG Interface' -- <change it>

Pages