• Home
• it.cnr.si.sigla
• sigla-backend
• 6.6.4
• source code
• V_STIPENDI_COFI_DETT.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

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

--------------------------------------------------------
--  DDL for View V_STIPENDI_COFI_DETT
--------------------------------------------------------

  CREATE OR REPLACE FORCE VIEW "V_STIPENDI_COFI_DETT" ("ESERCIZIO", "MESE", "TIPO_FLUSSO", "ENTRATA_SPESA") AS 
  SELECT DISTINCT
--
-- Date: 29/09/2006
-- Version: 1.0
--
-- Per la gestione dei Flussi Stipendiali
--
-- History:
--
-- Date: 29/09/2006
-- Version: 1.0
-- Creazione
--
-- Body:
--
 ESERCIZIO,
 MESE,
 TIPO_FLUSSO,
 'S'
FROM STIPENDI_COFI_OBB_SCAD_DETT
UNION ALL
 SELECT DISTINCT
 ESERCIZIO,
 MESE,
 TIPO_FLUSSO,
 'E'
FROM STIPENDI_COFI_CORI_DETT
;