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)
Drilldown from GL to Inventory Transactions, Inv to gl Link Query R12,Inventory to General ledger links, r12 ,Inv to gl drill down
Drilldown from GL to Inventory Transactions, Inv to gl Link Query R12,Inventory to General ledger links, r12 ,Inv to gl drill down Link bet...
-
Improving the performance of a blog can involve a variety of strategies, including optimizing the website's technical infrastructure, im...
-
Query to Get Profile value at any level SELECT distinct pot.user_profile_option_name Profile, DECODE ( a.profile_option_value, ...
-
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 ...
No comments:
Post a Comment