SELECT fcpl.user_concurrent_program_name ,
fcp.concurrent_program_name ,
par.column_seq_num ,
par.end_user_column_name ,
par.form_left_prompt prompt ,
par.enabled_flag ,
par.required_flag ,
par.display_flag ,
par.flex_value_set_id ,
ffvs.flex_value_set_name ,
flv.meaning default_type ,
par.DEFAULT_VALUE
FROM APPS.fnd_concurrent_programs fcp ,
APPS.fnd_concurrent_programs_tl fcpl ,
APPS.fnd_descr_flex_col_usage_vl par ,
APPS.fnd_flex_value_sets ffvs ,
APPS.fnd_lookup_values flv
WHERE fcp.concurrent_program_id = fcpl.concurrent_program_id
AND fcpl.LANGUAGE = 'US'
AND par.descriptive_flexfield_name = '$SRS$.'
|| fcp.concurrent_program_name
AND ffvs.flex_value_set_id = par.flex_value_set_id
AND flv.lookup_type(+) = 'FLEX_DEFAULT_TYPE'
AND flv.lookup_code(+) = par.default_type
AND flv.LANGUAGE(+) = USERENV ('LANG')
AND ffvs.flex_value_set_id=102362
