Query to fetch Concurrent Program and executables details
SELECT fcpv.user_concurrent_program_name program_name, fcpv.concurrent_program_name program_short_name, fat.application_name program_application_name, fcpv.description program_description, fe.executable_name , fe.execution_file_name , DECODE( fe.execution_method_code, 'I', 'PLSQL Stored Procedure', 'P', 'Report', 'L', 'SQL Loader','Q','SQL*Plus', fe.execution_method_code) execution_method, fu.user_name created_by, fcpv.creation_date FROM fnd_executables fe, fnd_application_tl fat, fnd_concurrent_programs_vl fcpv, fnd_user fu WHERE 1 =1 AND fe.application_id = fat.application_id AND fe.executable_id = fcpv.executable_id AND fat.language ='US' AND fu.user_id = fcpv.created_by AND fcpv.user_concurrent_program_name LIKE 'Trial Balance';