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