EBS R12 Account Value Set Details with Segment Qualifier Values Query

/*EBS R12 Account Value Set Details with Segment Qualifier Values Query*/

SELECT DISTINCT fv.flex_value VALUE, fv.flex_value_meaning meaning,
                fv.description, fv.start_date_active, fv.end_date_active,
                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_vl 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 fv.flex_value_set_id = 1015409--Account Value Set ID
            AND fv.enabled_flag = 'Y';