Conditional Constraint/index

 CREATE UNIQUE INDEX UN_NAME

   ON TABLE_NAME (

      (CASE

          WHEN STATUS = 'Y' THEN CLIENT_NO || ITEM_NO || COMPANY_NO

          ELSE NULL

       END));