CREATE OR ALTER VIEW TBMODELO_OBSERVACAO(
    MODELO_CODIGO,
    OBSERVACAO,
    DATA)
AS
select
    s.codigo MODELO_CODIGO,
    p.descricao_literal as OBSERVACAO,
    '01.01.2020' DATA
from tbmodelo s, produtos p
where p.id = s.codigo
and p.descricao_literal is not null
;

