SELECT /*fat.application_name
, fdfv.title
, fdfcv.descriptive_flex_context_code context
, fdfcuv.column_seq_num num
, fdfcuv.end_user_column_name name
, fdfcuv.application_column_name column_
, ffvs.flex_value_set_name value_set
, ffvs.description value_set_description
, fdfcuv.required_flag
, fdfcuv.display_flag
, fdfcuv.enabled_flag
, fdfcuv.security_enabled_flag
, fdfcuv.default_valu*/
*
FROM apps.fnd_descriptive_flexs_vl fdfv
, applsys.fnd_application_tl fat
, apps.fnd_descr_flex_contexts_vl fdfcv
, apps.fnd_descr_flex_col_usage_vl fdfcuv
, applsys.fnd_flex_value_sets ffvs
WHERE fdfv.application_id = fat.application_id
AND fdfcv.descriptive_flexfield_name = fdfv.descriptive_flexfield_name
AND fdfcv.descriptive_flexfield_name = fdfcuv.descriptive_flexfield_name
AND fdfcv.descriptive_flex_context_code = fdfcuv.descriptive_flex_context_code
AND fdfcuv.flex_value_set_id = ffvs.flex_value_set_id(+)
AND fdfv.title like '%NomeDoFDD%'
ORDER BY fat.application_name
, fdfv.title
, fdfcv.descriptive_flex_context_code
, fdfcuv.column_seq_num;
Orabr
Base e troca de conhecimentos, divulgação de oportunidades e projetos