Cross Validation Rules Headers

SELECT ffvrv.flex_validation_rule_name rule_name

     , ffvrv.enabled_flag enabled

     , ffvrv.creation_date created

     , cr_by.description created_by

     , cr_by.user_name

     , ffvrv.last_update_date updated

     , up_by.description updated_by

     , ffvrv.error_segment_column_name error_segment_basic

     , DECODE (ffvrv.error_segment_column_name

             , 'SEGMENT1', 'Blah'            

             , 'SEGMENT2', 'Blah Blah'

             , 'SEGMENT4', 'Blah Blah Blah'

             , 'SEGMENT3', 'Blah Blah Blah Blah'

             , NULL)

          error_segment

     , ffvrv.error_message_text error_message

     , ffvrv.description

  FROM apps.fnd_flex_vdation_rules_vl ffvrv

     , applsys.fnd_user cr_by

     , applsys.fnd_user up_by

 WHERE ffvrv.created_by = cr_by.user_id

   AND ffvrv.last_updated_by = up_by.user_id

   AND cr_by.user_name NOT IN ('AUTOINSTALL', 'INITIAL SETUP', 'SYSADMIN');