Query : Value Set Values with Qualifier Details (GL Account)

SELECT fv.flex_value_set_id
     , fv.flex_value_id
     , fv.flex_value
     , fv.compiled_value_attributes
     , SUBSTR( fv.compiled_value_attributes, 1, 1 ) allow_budgeting
     , SUBSTR( fv.compiled_value_attributes, 3, 1 ) allow_posting
     , SUBSTR( fv.compiled_value_attributes, 5, 1 ) account_type
     , SUBSTR( fv.compiled_value_attributes, 7, 1 ) third_party_ac_type
     , SUBSTR( fv.compiled_value_attributes, 9, 1 ) reconcile
  FROM fnd_flex_value_sets fvs, fnd_flex_values fv, fnd_flex_validation_qualifiers ffvq
 WHERE     fv.flex_value_set_id = fvs.flex_value_set_id
       AND ffvq.flex_value_set_id = fv.flex_value_set_id
       AND flex_value_set_name = 'XXGL_GBL_ACCOUNT'
       AND flex_value = '030099'
       AND fv.enabled_flag = 'Y';