---- How to Find and Script for the Value Set Name Using by Oracle Report or .rdf file in oracle apps EBS R12 ---
SELECT a.ucpname, a.cpname, a.param, f.flex_value_set_name, p_apromt_name, p_fpromt_name
FROM (SELECT v.concurrent_program_name cpname,
v.user_concurrent_program_name ucpname,
NVL (vc.end_user_column_name, 'NULL PARAM') param,
vc.form_above_prompt p_apromt_name,
vc.form_left_prompt p_fpromt_name,
NVL (vc.flex_value_set_id, 0) valueset
FROM fnd_concurrent_programs_vl v, fnd_descr_flex_col_usage_vl vc
WHERE v.user_concurrent_program_name LIKE '%'
AND v.application_id = vc.application_id(+)
AND vc.descriptive_flexfield_name(+) = '$SRS$.' || v.concurrent_program_name) a,
fnd_flex_value_sets f
WHERE a.valueset = f.flex_value_set_id(+)
--and f.FLEX_VALUE_SET_NAME like 'XX%'
AND a.ucpname like '%Stock Ledger'
SELECT a.ucpname, a.cpname, a.param, f.flex_value_set_name, p_apromt_name, p_fpromt_name
FROM (SELECT v.concurrent_program_name cpname,
v.user_concurrent_program_name ucpname,
NVL (vc.end_user_column_name, 'NULL PARAM') param,
vc.form_above_prompt p_apromt_name,
vc.form_left_prompt p_fpromt_name,
NVL (vc.flex_value_set_id, 0) valueset
FROM fnd_concurrent_programs_vl v, fnd_descr_flex_col_usage_vl vc
WHERE v.user_concurrent_program_name LIKE '%'
AND v.application_id = vc.application_id(+)
AND vc.descriptive_flexfield_name(+) = '$SRS$.' || v.concurrent_program_name) a,
fnd_flex_value_sets f
WHERE a.valueset = f.flex_value_set_id(+)
--and f.FLEX_VALUE_SET_NAME like 'XX%'
AND a.ucpname like '%Stock Ledger'
No comments:
Post a Comment