Value Sets

/* Formatted on 6/19/2013 2:41:15 PM (QP5 v5.114.809.3010) */
SELECT
    ffvs.flex_value_set_name                   "Value Set Name"
,   fu.user_name                                "Created By"
,   ffvt.application_table_name                 "Tables"
,   ffvt.id_column_name||decode(ffvt.id_column_name,null,null,',')||
    ffvt.value_column_name||decode(ffvt.meaning_column_name,null,null,',')||
    ffvt.meaning_column_name                    "Columns"
,   ffvt.additional_where_clause                "Where"
FROM      fnd_flex_validation_tables                ffvt
,         fnd_user                                  fu
,         fnd_flex_value_sets                       ffvs
WHERE     ffvs.flex_value_set_id = ffvt.flex_value_set_id
AND       ffvs.created_by = fu.user_id
AND      ( ffvs.created_by NOT IN (-1,1,0,2)
or  ffvs.created_by NOT IN (-1,1,0,2) )
AND       ffvs.validation_type = 'F'
AND       ffvs.flex_value_set_name not like 'SA -%'
ORDER BY 1,2"