Script to fetch the following details
1. Concurrent Program Name
2. Concurrent Program Short Name
3. Concurrent Program Application Name
4. Executable Name
5. Executable Short Name
6. Executable Application Name
7. Execution Method
8. Execution file Name
9. Enable Trace flag
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 |
SELECT fcpt.user_concurrent_program_name , fcp.concurrent_program_name short_name , fat.application_name program_application_name , fet.executable_name , fat1.application_name executable_application_name , flv.meaning execution_method , fet.execution_file_name , fcp.enable_trace FROM fnd_concurrent_programs_tl fcpt , fnd_concurrent_programs fcp , fnd_application_tl fat , fnd_executables fet , fnd_application_tl fat1 , FND_LOOKUP_VALUES FLV WHERE 1 =1 AND fcpt.user_concurrent_program_name=’Supplier Audit Report’ AND fcpt.concurrent_program_id = fcp.concurrent_program_id AND fcpt.application_id = fcp.application_id AND fcp.application_id = fat.application_id AND fcpt.application_id = fat.application_id AND fcp.executable_id = fet.executable_id AND fcp.executable_application_id = fet.application_id AND fet.application_id = fat1.application_id AND flv.lookup_code = fet.execution_method_code AND FLV.LOOKUP_TYPE =’CP_EXECUTION_METHOD_CODE’ ; |