Reports2017-11-18T12:27:27+00:00

FND Concurrent Programs and Executables

Description
Categories: Application, Enginatics, Setup
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,
flv1.meaning method,
fev.execution_file_name,
flv2.meaning output_format,
decode(fcpv.multi_org_category,'M','Multiple','S','Single') operating_unit_mode,
&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,
fcpv.creation_date,
xxen_util.user_name(fcpv.last_updated_by) last_updated_by,
fcpv.last_update_date
from
fnd_application_vl fav,
fnd_concurrent_programs_vl fcpv,
fnd_executables_vl fev,
fnd_lookup_values flv1,
fnd_lookup_values flv2,
fnd_lookup_values flv3,
(select fdfcuv.* from fnd_descr_flex_col_usage_vl fdfcuv where '&enable_parameters'='Y') fdfcuv,
fnd_flex_value_sets ffvs
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
fev.execution_method_code=flv1.lookup_code(+) and
fcpv.output_file_type=flv2.lookup_code(+) and
fdfcuv.default_type=flv3.lookup_code(+) and
flv1.lookup_type(+)='CP_EXECUTION_METHOD_CODE' and
flv2.lookup_type(+)='CP_OUTPUT_FILE_TYPE' and
flv3.lookup_type(+)='FLEX_DEFAULT_TYPE' and
flv1.language(+)=userenv('lang') and
flv2.language(+)=userenv('lang') and
flv3.language(+)=userenv('lang') and
flv1.view_application_id(+)=0 and
flv2.view_application_id(+)=0 and
flv3.view_application_id(+)=0 and
flv1.security_group_id(+)=0 and
flv2.security_group_id(+)=0 and
flv3.security_group_id(+)=0 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(+)
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
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
upper(fcpv.user_concurrent_program_name) like upper(:user_concurrent_program_name)
LOV
Application Short Name
fav.application_short_name=:short_name
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,
flv3.meaning default_type,
fdfcuv.default_value,
decode(fdfcuv.required_flag,'Y','Yes') required,
decode(fdfcuv.display_flag,'Y','Yes') display,
Show Parameters
Y
LOV Oracle
Output Format
flv2.meaning=:output_format
LOV
Execution File Name (Package)
lower(fev.execution_file_name) like lower(:execution_file_name)
Execution Method
flv1.meaning=:execution_method
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
Executable Name
fev.user_executable_name=:executable_name
LOV
Creation Date From
fcpv.creation_date>=:creation_date_from
Date