expsigladb.View.VM_COSTI_DIP_PREV_PRE_VIEW.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of sigla-backend Show documentation

There is a newer version: 6.6.11

--------------------------------------------------------
--  DDL for View VM_COSTI_DIP_PREV_PRE_VIEW
--------------------------------------------------------

  CREATE OR REPLACE FORCE VIEW "VM_COSTI_DIP_PREV_PRE_VIEW" ("ESERCIZIO", "TI_PREV_CONS", "MATRICOLA", "TI_APPARTENENZA", "TI_GESTIONE", "CD_ELEMENTO_VOCE", "CD_UNITA_ORGANIZZATIVA", "IM_A1", "IM_A2", "IM_A3", "IM_ONERI_CNR_A1", "IM_ONERI_CNR_A2", "IM_ONERI_CNR_A3", "IM_TFR_A1", "IM_TFR_A2", "IM_TFR_A3") AS 
  SELECT
-- =================================================================================================
-- Date: 01/12/2003
-- Version 1.0
--
-- Creazione vista
--
-- =================================================================================================
        A.anno_gest + 1,
        'P',
        A.matricola,
        'D',
        'S',
        A.voce_cia,
        DECODE(A.tit, NULL, NULL, SUBSTR(A.tit,1,3) || '.' || SUBSTR(A.tit,4,3)),
        DECODE(A.anno_gest + 1, A.anno_prev, A.impo_annuo, 0),
        DECODE(A.anno_gest + 2, A.anno_prev, A.impo_annuo, 0),
        DECODE(A.anno_gest + 3, A.anno_prev, A.impo_annuo, 0),
        DECODE(A.anno_gest + 1, A.anno_prev, A.oneri_cnr, 0),
        DECODE(A.anno_gest + 2, A.anno_prev, A.oneri_cnr, 0),
        DECODE(A.anno_gest + 3, A.anno_prev, A.oneri_cnr, 0),
        DECODE(A.anno_gest + 1, A.anno_prev, A.tfr, 0),
        DECODE(A.anno_gest + 2, A.anno_prev, A.tfr, 0),
        DECODE(A.anno_gest + 3, A.anno_prev, A.tfr, 0)
FROM    CNR_COSTI_PREV A
;