Find Value Set Detail

Select a.Descriptive_Flexfield_Name,
       a.Application_Column_Name,
       a.End_User_Column_Name,
       a.Flex_Value_Set_Id,
       c.Flex_Value_Set_Name,
       a.Display_Size,
       b.Application_Table_Name,
       b.Value_Column_Name,
       b.Value_Column_Type,
       b.Value_Column_Size,
       b.Id_Column_Name,
       b.Id_Column_Type,
       b.Id_Column_Size,
       b.Meaning_Column_Name,
       b.Meaning_Column_Type,
       b.Meaning_Column_Size
  From Fnd_Descr_Flex_Column_Usages a,
       Fnd_Flex_Validation_Tables   b,
       Fnd_Flex_Value_Sets          c

 Where /*a.CREATION_DATE >= to_date('01-JAN-2015')
And  */
 a.Flex_Value_Set_Id = b.Flex_Value_Set_Id
 And c.Flex_Value_Set_Id = a.Flex_Value_Set_Id
 And a.Descriptive_Flexfield_Name = '$SRS$.FCI_PAYMENT_RECEIPT'
 Order By a.Creation_Date Desc