CREATE OR REPLACE FORCE VIEW "OAT_APP"."TOPIC_MEASURE_SET_VW" ("TOPC_ID", "TOPC_NAME", "TOPC_DESC", "ADMSN_TYP_ID") AS
  SELECT c.topic_id          AS topc_id,
       c.topic             AS topc_name,
       c.topic_description AS topc_desc,
       1                   AS admsn_typ_id
  FROM cart.topic c
UNION
SELECT m.msr_set_id,
       m.msr_set_name,
       m.msr_set_desc,
       2 AS admsn_typ_id
  FROM opps_import.measure_set m