Monday, March 31, 2014

Oracle EBS - DFF Segments Values

SELECT fdfv.title, fdfv.application_table_name, fdfv.context_column_name,
               fdfcu.descriptive_flexfield_name,
               fdfcu.descriptive_flex_context_code, fdfcu.column_seq_num,
               fdfcu.application_column_name, fdfcu.end_user_column_name
   FROM fnd_descr_flex_col_usage_vl fdfcu, fnd_descriptive_flexs_vl fdfv
 WHERE fdfv.title = 'Line Transaction Flexfield'
      AND fdfcu.descriptive_flexfield_name = fdfv.descriptive_flexfield_name
      AND fdfcu.application_id = fdfv.application_id
 ORDER BY fdfcu.descriptive_flexfield_name,
               fdfcu.descriptive_flex_context_code,
               fdfcu.column_seq_num;

No comments:

Post a Comment