EFF - Flexfield Segment Details

SELECT fdst.DESCRIPTIVE_FLEXFIELD_CODE,
       fdst.CONTEXT_CODE,
       fdst.SEGMENT_CODE,
       fdst.NAME,
       fdsb.application_ID,
       fdsb.descriptive_flexfield_code,
       fdsb.context_code,
       fdsb.segment_code,
       fdsb.SEGMENT_IDENTIFIER,
       fdsb.column_name,
       fdsb.sequence_number,
       fdsb.enabled_flag,
       fdsb.required_flag,
       fdsb.value_set_id,
       fdsb.default_type,
       fdsb.default_value,
       fdsb.derivation_value,
       fdsb.range_type,
       fdsb.Read_only_flag,
       fdsb.display_type,
       fdsb.display_width,
       fdsb.display_height,
       fdsb.checkbox_checked_value,
       fdsb.checkbox_unchecked_value
FROM fnd_df_segments_tl fdst,
     fnd_df_segments_b  fdsb
WHERE fdst.APPLICATION_ID                 = fdsb.APPLICATION_ID
  AND fdst.ENTERPRISE_ID                  = fdsb.ENTERPRISE_ID
  AND fdst.DESCRIPTIVE_FLEXFIELD_CODE     = fdsb.DESCRIPTIVE_FLEXFIELD_CODE
  AND fdst.CONTEXT_CODE                   = fdsb.CONTEXT_CODE
  AND fdst.SEGMENT_CODE                   = fdsb.SEGMENT_CODE
  AND fdst.language                       = 'US'
  AND fdst.descriptive_flexfield_code    = 'DOO_FULFILL_LINES_ADD_INFO'
ORDER BY fdst.CONTEXT_CODE,
         fdsb.SEQUENCE_NUMBER;