Oracle EBS find information related to concurrent program and parameters using SQL Query
SELECT fcpl.user_concurrent_program_name
, fcp.concurrent_program_name
, fav.APPLICATION_SHORT_NAME
, fdfcuv.COLUMN_SEQ_NUM sequence
, fdfcuv.end_user_column_name
, fdfcuv.description
, fdfcuv.srw_param token
, fdfcuv.form_left_prompt prompt
, fdfcuv.enabled_flag
, fdfcuv.required_flag
, fdfcuv.display_flag
, fdfcuv.DISPLAY_SIZE
, fdfcuv.MAXIMUM_DESCRIPTION_LEN
, fdfcuv.CONCATENATION_DESCRIPTION_LEN
, ffvs.flex_value_set_name
, flv.meaning default_type
, fdfcuv.DEFAULT_VALUE
FROM apps.fnd_concurrent_programs fcp
, apps.fnd_concurrent_programs_tl fcpl
, apps.fnd_descr_flex_col_usage_vl fdfcuv
, apps.fnd_flex_value_sets ffvs
, apps.fnd_lookup_values flv
, apps.fnd_application fav
WHERE fcp.concurrent_program_id = fcpl.concurrent_program_id
and fcp.application_id = fcpl.application_id
and fcp.concurrent_program_name like ‘AB%’ — change it as needed
AND fav.application_id=fcp.application_id
AND fdfcuv.descriptive_flexfield_name = ‘$SRS$.’ || fcp.concurrent_program_name
and fdfcuv.application_id = fcp.application_id
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
order by fcpl.user_concurrent_program_name ;