SELECT
application_name,
user_concurrent_program_name,
meaning Program_Type,
output_file_type output_format,
-- concurrent_program_id,
-- cp.application_id,--ce.*,
executable_name,
execution_file_name
FROM
FND_CONCURRENT_PROGRAMS_VL cp ,
FND_EXECUTABLES_FORM_V ce ,
fnd_lookup_values flv
WHERE
cp.executable_id = ce.executable_id
AND ce.execution_method_code = lookup_code
AND lookup_type = 'CP_EXECUTION_METHOD_CODE'
AND user_concurrent_program_name LIKE '%Program Name%'
;
application_name,
user_concurrent_program_name,
meaning Program_Type,
output_file_type output_format,
-- concurrent_program_id,
-- cp.application_id,--ce.*,
executable_name,
execution_file_name
FROM
FND_CONCURRENT_PROGRAMS_VL cp ,
FND_EXECUTABLES_FORM_V ce ,
fnd_lookup_values flv
WHERE
cp.executable_id = ce.executable_id
AND ce.execution_method_code = lookup_code
AND lookup_type = 'CP_EXECUTION_METHOD_CODE'
AND user_concurrent_program_name LIKE '%Program Name%'
;