• Home
• it.cnr.si.sigla
• sigla-backend
• 6.6.4
• source code
• V_DISP_CASSA_CNR.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_DISP_CASSA_CNR.sql Maven / Gradle / Ivy

--------------------------------------------------------
--  DDL for View V_DISP_CASSA_CNR
--------------------------------------------------------

  CREATE OR REPLACE FORCE VIEW "V_DISP_CASSA_CNR" ("ESERCIZIO", "CD_CDS", "IM_DISPONIBILTA_CASSA") AS 
  Select /*+ optimizer_features_enable('10.1.0') */
 a.ESERCIZIO,
 a.CD_CDS,
 disp_cassa_mandati(esercizio,cd_cds) IM_DISP_CASSA
FROM    ESERCIZIO a
WHERE
 exists ( select 1 from v_unita_organizzativa_valida where
               esercizio = a.esercizio
		   and cd_tipo_unita = 'ENTE'
		   and cd_unita_organizzativa = a.cd_cds
        ) ;