SELECT ffv.descriptive_flexfield_name,
ffv.application_table_name,
ffv.title,
ap.application_name ,
ffc.descriptive_flex_context_code ,
ffc.descriptive_flex_context_name,
ffc.description ,
ffc.enabled_flag ,
att.column_seq_num ,
att.form_left_prompt ,
att.application_column_name ,
fvs.flex_value_set_name ,
att.display_flag ,
att.enabled_flag ,
att.required_flag
FROM fnd_descriptive_flexs_vl ffv,
fnd_descr_flex_contexts_vl ffc,
fnd_descr_flex_col_usage_vl att,
fnd_flex_value_sets fvs,
fnd_application_vl ap
WHERE ffv.descriptive_flexfield_name = att.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=att.descriptive_flex_context_code
AND fvs.flex_value_set_id =att.flex_value_set_id
AND ap.application_name = 'Order Management'
AND ffv.application_table_name ='OE_ORDER_HEADERS_ALL';
ffv.application_table_name,
ffv.title,
ap.application_name ,
ffc.descriptive_flex_context_code ,
ffc.descriptive_flex_context_name,
ffc.description ,
ffc.enabled_flag ,
att.column_seq_num ,
att.form_left_prompt ,
att.application_column_name ,
fvs.flex_value_set_name ,
att.display_flag ,
att.enabled_flag ,
att.required_flag
FROM fnd_descriptive_flexs_vl ffv,
fnd_descr_flex_contexts_vl ffc,
fnd_descr_flex_col_usage_vl att,
fnd_flex_value_sets fvs,
fnd_application_vl ap
WHERE ffv.descriptive_flexfield_name = att.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=att.descriptive_flex_context_code
AND fvs.flex_value_set_id =att.flex_value_set_id
AND ap.application_name = 'Order Management'
AND ffv.application_table_name ='OE_ORDER_HEADERS_ALL';
No comments:
Post a Comment