SELECT ffv.descriptive_flexfield_name DFFName,
ffv.application_table_name ,
ffv.title ,
ap.application_name ,
ffc.descriptive_flex_context_code ,
ffc.descriptive_flex_context_name ,
ffc.description ,
ffc.enabled_flag,
ffcu.column_seq_num ,
ffcu.form_left_prompt ,
ffcu.application_column_name ,
ffvs.flex_value_set_name ,
ffcu.display_flag ,
ffcu.enabled_flag ,
ffcu.required_flag
FROM apps.fnd_descriptive_flexs_vl ffv,
apps.fnd_descr_flex_contexts_vl ffc,
apps.fnd_descr_flex_col_usage_vl ffcu,
apps.fnd_flex_value_sets ffvs,
apps.fnd_application_vl ap
WHERE ffv.descriptive_flexfield_name = ffcu.descriptive_flexfield_name
AND ap.application_id=ffv.application_id
AND ffv.descriptive_flexfield_name = ffc.descriptive_flexfield_name
AND ffv.application_id = ffc.application_id
AND ffc.descriptive_flex_context_code=ffcu.descriptive_flex_context_code
AND ffvs.flex_value_set_id=ffcu.flex_value_set_id
and ap.application_name=&Application_name
AND ffv.title like &DFF_title
AND ffc.descriptive_flex_context_code like &DFF_context_code
ORDER BY ffcu.column_seq_num
;
ffv.application_table_name ,
ffv.title ,
ap.application_name ,
ffc.descriptive_flex_context_code ,
ffc.descriptive_flex_context_name ,
ffc.description ,
ffc.enabled_flag,
ffcu.column_seq_num ,
ffcu.form_left_prompt ,
ffcu.application_column_name ,
ffvs.flex_value_set_name ,
ffcu.display_flag ,
ffcu.enabled_flag ,
ffcu.required_flag
FROM apps.fnd_descriptive_flexs_vl ffv,
apps.fnd_descr_flex_contexts_vl ffc,
apps.fnd_descr_flex_col_usage_vl ffcu,
apps.fnd_flex_value_sets ffvs,
apps.fnd_application_vl ap
WHERE ffv.descriptive_flexfield_name = ffcu.descriptive_flexfield_name
AND ap.application_id=ffv.application_id
AND ffv.descriptive_flexfield_name = ffc.descriptive_flexfield_name
AND ffv.application_id = ffc.application_id
AND ffc.descriptive_flex_context_code=ffcu.descriptive_flex_context_code
AND ffvs.flex_value_set_id=ffcu.flex_value_set_id
and ap.application_name=&Application_name
AND ffv.title like &DFF_title
AND ffc.descriptive_flex_context_code like &DFF_context_code
ORDER BY ffcu.column_seq_num
;
No comments:
Post a Comment