FND Concurrent Programs and Executables 11i

Description
Categories: Enginatics
Repository: Github Columns: Program, Description, Application Name, Application Short Name, Short Name, Executable Short Name, Method, Execution File Name, Options, Output Format ...
Concurrent programs, executables and program parameters
select
fcpv.user_concurrent_program_name program,
fcpv.description,
fav.application_name,
fav.application_short_name,
fcpv.concurrent_program_name short_name,
fev.executable_name executable_short_name,
xxen_util.meaning(fev.execution_method_code,'CP_EXECUTION_METHOD_CODE',0) method,
fev.execution_file_name,
fcpv.execution_options options,
xxen_util.meaning(fcpv.output_file_type,'CP_OUTPUT_FILE_TYPE',0) output_format,
fcrc.request_class_name type,
fcpv.increment_proc incrementor,
&column_parameters
case when fev.description is null and fev.user_executable_name<>fev.executable_name then fev.user_executable_name else fev.description end executable_description,
xxen_util.user_name(fcpv.created_by) created_by,
xxen_util.client_time(fcpv.creation_date) creation_date,
xxen_util.user_name(fcpv.last_updated_by) last_updated_by,
xxen_util.client_time(fcpv.last_update_date) last_update_date,
fcpv.concurrent_program_id
from
fnd_application_vl fav,
fnd_concurrent_programs_vl fcpv,
fnd_executables_vl fev,
(select fdfcuv.* from fnd_descr_flex_col_usage_vl fdfcuv where '&enable_parameters'='Y') fdfcuv,
fnd_flex_value_sets ffvs,
fnd_concurrent_request_class fcrc
where
1=1 and
fav.application_id=fcpv.application_id and
fcpv.executable_application_id=fev.application_id and
fcpv.executable_id=fev.executable_id and
fcpv.application_id=fdfcuv.application_id(+) and
'$SRS$.'||fcpv.concurrent_program_name=fdfcuv.descriptive_flexfield_name(+) and
fdfcuv.descriptive_flex_context_code(+)='Global Data Elements' and
fdfcuv.flex_value_set_id=ffvs.flex_value_set_id(+) and
fcpv.class_application_id=fcrc.application_id(+) and
fcpv.concurrent_class_id=fcrc.request_class_id(+)
order by
fav.application_name,
fcpv.user_concurrent_program_name,
fdfcuv.column_seq_num
Parameter Name SQL text Validation
Application Name
fav.application_name=:application_name
LOV
Concurrent Program Short Name
upper(fcpv.concurrent_program_name) like upper(:concurrent_program_name)
LOV
Show Parameters
Y
LOV
Executable Short Name
fev.executable_name=:executable_short_name
LOV
Concurrent Progr. (all languages)
fcpv.user_concurrent_program_name in (
select
fcpt.user_concurrent_program_name
from
fnd_concurrent_programs_tl fcpt0,
fnd_concurrent_programs_tl fcpt
where
fcpt0.user_concurrent_program_name=:user_conc_name_all_languages and
fcpt0.application_id=fcpt.application_id and
fcpt0.concurrent_program_id=fcpt.concurrent_program_id and
fcpt.language=userenv('lang')
)
LOV
Concurrent Program Name like
upper(fcpv.user_concurrent_program_name) like upper(:user_concurrent_program_name)
LOV
Application Short Name
fav.application_short_name=:short_name
LOV
Execution Method
fev.execution_method_code=xxen_util.lookup_code(:execution_method,'CP_EXECUTION_METHOD_CODE',0)
LOV
Creation Date From
fcpv.creation_date>=:creation_date_from
Date
Executable Name
fev.user_executable_name=:executable_name
LOV
Executable Description
case when fev.description is null and fev.user_executable_name<>fev.executable_name then fev.user_executable_name else fev.description end=:executable_description
LOV
Execution File Name (Package)
lower(fev.execution_file_name) like lower(:execution_file_name)
Output Format
fcpv.output_file_type=xxen_util.lookup_code(:output_format,'CP_OUTPUT_FILE_TYPE',0)
LOV
Parameter Default Type
fdfcuv.default_type=xxen_util.lookup_code(:parameter_default_type,'FLEX_DEFAULT_TYPE',0)
LOV
Show Parameters
fdfcuv.column_seq_num parameter_sequence,
fdfcuv.end_user_column_name parameter,
fdfcuv.form_left_prompt prompt,
fdfcuv.srw_param token,
ffvs.flex_value_set_name value_set,
xxen_report.oracle_lov_query(ffvs.flex_value_set_id) lov_query,
xxen_util.meaning(fdfcuv.default_type,'FLEX_DEFAULT_TYPE',0) default_type,
fdfcuv.default_value,
decode(fdfcuv.required_flag,'Y','Yes') required,
decode(fdfcuv.display_flag,'Y','Yes') display,
ffvs.flex_value_set_id,
Parameter Default Type
fdfcuv.column_seq_num parameter_sequence,
fdfcuv.end_user_column_name parameter,
fdfcuv.form_left_prompt prompt,
fdfcuv.srw_param token,
ffvs.flex_value_set_name value_set,
xxen_report.oracle_lov_query(ffvs.flex_value_set_id) lov_query,
xxen_util.meaning(fdfcuv.default_type,'FLEX_DEFAULT_TYPE',0) default_type,
fdfcuv.default_value,
decode(fdfcuv.required_flag,'Y','Yes') required,
decode(fdfcuv.display_flag,'Y','Yes') display,
Parameter Default Type
Y