SELECT DISTINCTFA. Application_short_name, FA. BasePath, Fat. Application_name, fe. Executable_name, fe. Execution_file_name, FCP. Concurrent_program_name, FCP. Output_file_type, FCP. Output_print_style, Fcpt.user_concurrent_program_name, Fcpt.language, fcpt.de Scription, Fcp.enabled_flag fromfnd_application_tl fat, fnd_application fa, Fnd_concurrent_programs_tl fcpt, Fnd_concurrent_program S FCP, Fnd_executables feWHERE 1 = 1 andFat. application_id=FA. application_id andFat. LANGUAGE=FCPT. LANGUAGE andFa. application_id=FCP. application_id andFcpt. LANGUAGE= 'ZHS' andFcpt. concurrent_program_id=FCP. concurrent_program_id andfcp.executable_id=fe.executable_id andFcp.enabled_flag= 'Y' ----whether to enable andFcpt.user_concurrent_program_name like 'cux%' --the short name of the report to query
Concurrency program definition query SQL in Oracle EBS