R12 GL Natural Acct

/* Formatted on 01-09-2011 10:55:55 (QP5 v5.115.810.9015) */
  SELECT  
 FLEX_VALUE ACCOUNT_CODE,
           DESCRIPTION ACCT_DESC,
           ENABLED_FLAG STATUS,
           START_DATE_ACTIVE,
           END_DATE_ACTIVE
    FROM   FND_FLEX_VALUES_VL
   WHERE   ( ('' IS NULL)
            OR (structured_hierarchy_level IN
                      (SELECT   hierarchy_id
                         FROM   fnd_flex_hierarchies_vl h
                        WHERE   h.flex_value_set_id = 1014870
                                AND h.hierarchy_name LIKE '')))
           AND (FLEX_VALUE_SET_ID = 1014870)
ORDER BY   flex_value