/* Formatted on 6/19/2013 12:15:15 PM (QP5 v5.114.809.3010) */
SELECT user_concurrent_program_name "Program",
concurrent_program_name "Short Name",
application_name "Application",
fcp.description,
executable_name,
execution_file_name,
fl1.meaning "Execution Method",
output_file_type,
application_short_name,
basepath
FROM fnd_executables fne,
fnd_application_vl fapl,
fnd_concurrent_programs_vl fcp,
fnd_lookups fl1
WHERE 1 = 1
AND fne.application_id = fapl.application_id
AND fcp.application_id = fapl.application_id
AND fne.EXECUTABLE_ID = fcp.EXECUTABLE_ID
AND fcp.execution_method_code = fl1.lookup_code(+)
AND fl1.lookup_type = 'CP_EXECUTION_METHOD_CODE'
AND fapl.application_short_name = : custom_path
SELECT user_concurrent_program_name "Program",
concurrent_program_name "Short Name",
application_name "Application",
fcp.description,
executable_name,
execution_file_name,
fl1.meaning "Execution Method",
output_file_type,
application_short_name,
basepath
FROM fnd_executables fne,
fnd_application_vl fapl,
fnd_concurrent_programs_vl fcp,
fnd_lookups fl1
WHERE 1 = 1
AND fne.application_id = fapl.application_id
AND fcp.application_id = fapl.application_id
AND fne.EXECUTABLE_ID = fcp.EXECUTABLE_ID
AND fcp.execution_method_code = fl1.lookup_code(+)
AND fl1.lookup_type = 'CP_EXECUTION_METHOD_CODE'
AND fapl.application_short_name = : custom_path
No comments:
Post a Comment