INSERT INTO some_table ( 
   key_attr,
   value_first,
   value_second,
   value_third,
  value_fourth
)
with 
base as (
	SELECT * from some_view1 
),
cst_party_rel AS
(
  SELECT key_attr, code, label_value
    FROM some_view2
   WHERE code                                          IN ( 'LABEL_FIRST'
                                                            , 'LABEL_SECOND'
                                                            , 'LABEL_THIRD'
                                                            , 'LABEL_FOURTH'
                                                          )
)
SELECT base.key_attr, 
	cst_first.label_value      as value_first,
	cst_second.label_value     as value_second,
	cst_third.label_value      as value_third,
	cst_fourth.label_value     as value_fourth
FROM     some_trash.base   
         LEFT OUTER JOIN
         some_trash.cst_party_rel                                    cst_first
         ON (     cst_first.key_attr                               = base.key_attr
              AND cst_first.code                                   = 'LABEL_FIRST'
            )
         LEFT OUTER JOIN
         some_trash.cst_party_rel                                    cst_second
         ON (    cst_second.key_attr                              = base.key_attr
              AND cst_second.code                                  = 'LABEL_SECOND'
            )
         LEFT OUTER JOIN
         some_trash.cst_party_rel                                    cst_third
         ON (      cst_third.key_attr                               = base.key_attr
              AND cst_third.code                                     = 'LABEL_THIRD'
            )
         LEFT OUTER JOIN
         some_trash.cst_party_rel                                    cst_fourth
         ON (   cst_fourth.key_attr                               = base.key_attr
              AND cst_fourth.code                                  = 'LABEL_FOURTH'
            )

with x as (select sysdate from dual)
select * from utter_bollocks.x;