SELECT fcpl.user_concurrent_program_name,
fcp.concurrent_program_name,
par.end_user_column_name,
par.form_left_prompt prompt,
par.enabled_flag,
par.required_flag,
par.display_flag,
ffv.flex_value_set_name
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 ffv
WHERE fcp.concurrent_program_id = fcpl.concurrent_program_id
AND fcpl.user_concurrent_program_name like '%Concurrent Program Name%'
AND fcpl.LANGUAGE = 'US'
AND par.descriptive_flexfield_name =
'$SRS$.' || fcp.concurrent_program_name
AND ffv.flex_value_set_id = par.flex_value_set_id;
Hello Sir,
ReplyDeleteI have a one doubt regarding procurement and finance so please help me
please reply me if you available or some free time u have to
ReplyDeleteMail ID - vishalsonyabapushinde@gmail.com