Paste code

CREATE MULTISET TABLE ..................T1_VPC_SUNAT_DEUDA_TRIBUTARIA_HIST AS (
              SELECT A.FECCARGA,  TRIM(A.NUMRUC) NUMRUC, 
                SUM(MONTODEUDATRIBUTO)  MONTODEUDATRIBUTO,
                MIN(FECINICIOPROCESOTRIBUTO)  FECINICIOPROCESOTRIBUTO,
                CASE WHEN MAX(FECINICIOPROCESOTRIBUTO) IS NULL THEN 0
                           ELSE MONTHS_BETWEEN(CAST(FECCARGA AS DATE FORMAT &#039;YYYYMM&#039;),CAST(MIN(FECINICIOPROCESOTRIBUTO) AS DATE FORMAT &#039;YYYYMM&#039;)) / 12 END TIEMPO_DEUDA_TRIBUTARIA,
                CASE WHEN SUM(MONTODEUDATRIBUTO) = 0 THEN 0 ELSE COUNT(CODDOCTRIBUTO) END CNT_DEUDAS_TRIBUTARIAS,
               &#039;202109&#039; PERIODO_VAL -- MES PARAMETRO (mes actual - 1 , a que se debe correr el 1ero de cada mes) varia por caja ejecucion del job
             FROM ..................V_CONSOLIDADO_SUNAT_HIST A
       WHERE 1 = 1
      AND ESTADOTRIBUTO = 0
      AND SUBSTR(NUMRUC,1,2) IN (&#039;15&#039;,&#039;17&#039;,&#039;20&#039;,&#039;10&#039;)
      AND A.FECCARGA =  -- &#039;PERIODO_A_COPIAR_DE_SUNAT_HIST&#039;
      --AND A.NUMRUC IN ( 
      --       &#039;20194658371&#039;,
      --     &#039;20390455080&#039;,
      --     &#039;20207967158&#039;,
      --     &#039;20339968455&#039;,
      --     &#039;20121142148&#039;,
      --     &#039;20602767915&#039;,
      --     &#039;20100915783&#039;,
      --     &#039;10700199849&#039;,
      --     &#039;20553853355&#039;,
      --     &#039;10069686716&#039;,
      --     &#039;10101719451&#039;,
      --     &#039;20600847300&#039;
      --  )
      GROUP BY A.FECCARGA,  TRIM(A.NUMRUC)
 )  WITH DATA AND STATS;