SELECT DISTINCT fcpl.user_concurrent_program_name "Concurrent Program Name", fcp.concurrent_program_name "Short Name" , fat.application_name , fl.meaning execution_method , fe.execution_file_name , fcp.output_file_type , fdfcuv.column_seq_num "Column Seq Number" , fdfcuv.end_user_column_name "Parameter Name" , fdfcuv.form_left_prompt "Prompt" , fdfcuv.enabled_flag " Enabled Flag" , fdfcuv.required_flag "Required Flag" , fdfcuv.display_flag "Display Flag" , fdfcuv.flex_value_set_id "Value Set Id" , ffvs.flex_value_set_name "Value Set Name" , flv.meaning "Default Type" , fdfcuv.default_value "Default Value" FROM fnd_concurrent_programs fcp , fnd_concurrent_programs_tl fcpl , fnd_descr_flex_col_usage_vl fdfcuv, fnd_flex_value_sets ffvs , fnd_lookup_values flv , fnd_lookups fl , fnd_executables fe , fnd_executables_tl fet , fnd_application_tl fat WHERE 1 = 1AND fcp.concurrent_program_id = fcpl.concurrent_program_id AND fcp.enabled_flag = 'Y'AND fcpl.user_concurrent_program_name LIKE 'Workflow Background Process' --<Your Concurrent Program Name>AND fdfcuv.descriptive_flexfield_name = '$SRS$.' || fcp.concurrent_program_name AND ffvs.flex_value_set_id = fdfcuv.flex_value_set_id AND flv.lookup_type(+) = 'FLEX_DEFAULT_TYPE'AND flv.lookup_code(+) = fdfcuv.default_type AND fcpl.LANGUAGE = 'US'AND flv.LANGUAGE(+) = 'US'AND fl.lookup_type ='CP_EXECUTION_METHOD_CODE'AND fl.lookup_code =fcp.execution_method_code AND fe.executable_id = fcp.executable_id AND fe.executable_id =fet.executable_id AND fet.LANGUAGE = 'US'AND fat.application_id =fcp.application_id AND fat.LANGUAGE = 'US'ORDER BY fdfcuv.column_seq_num;
Wednesday, August 24, 2016
SQL Query to findout Executable, Concurrent Program and its Parameters information
Subscribe to:
Post Comments (Atom)
Types of animations
Animation is a diverse and creative field with a variety of styles that artists and filmmakers use to bring their visions to life. Here are ...
-
Approval Management Engine FAQ 1. AME – What is it? i. AME is a simple to use Rules Engine for Defining Approval Policy ii. AME is ...
-
Register Custom Tables in Oracle Apps Say you have a custom table called “ERPS_EMPL...
-
OU & ORG ID & ORG CODE & ORG NAME ================================== select OPERATING_UNIT,ORGANIZATION_ID,ORGANIZATION_CODE...
No comments:
Post a Comment