🏠 Menú principal

← Volver a vistas materializadas

---

SIMACMOBILE.AXR_PARTCOMPS

Base de datos origen: ORCLSMM

Tipo de objeto: MATERIALIZED VIEW

SQL

  CREATE MATERIALIZED VIEW "SIMACMOBILE"."AXR_PARTCOMPS" ("CODSOCIEDAD", "CODCLI", "NDOC", "NVCTO", "FCHEMI", "FCHVCTO", "FCHCOMP", "IMPORTE", "MARCA", "IMPMONDOC", "CODMONDOC", "IND1", "IND2", "IND3", "IND4", "IND5", "IND6", "IND7", "IND8", "IND9", "TDOC", "CAMPOID", "CODEJERCICIO", "CODEJERCICIOCOMP", "NUMDOCCOBRO", "NUMDOCORIGEN", "CODVIAPAGO")
  SEGMENT CREATION IMMEDIATE
  ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS NOLOGGING
  BUILD IMMEDIATE
  USING INDEX 
  REFRESH COMPLETE ON DEMAND
  USING DEFAULT LOCAL ROLLBACK SEGMENT
  USING ENFORCED CONSTRAINTS DISABLE ON QUERY COMPUTATION DISABLE QUERY REWRITE
  AS SELECT DISTINCT
  '890300225' CODSOCIEDAD,
  CLIE.SITE AS CODCLI,
  REPA.NUMERO_FACTURA AS NDOC,
  REPA.NUMERO_CUOTA AS NVCTO, 
  REPA.FECHA_FACTURA AS FCHEMI,
  CASE 
      WHEN FACX.ID_FACERP IS NULL THEN ADD_MONTHS(REPA.FECHA_FACTURA ,1) 
      WHEN FACX.NUMERO_CUOTA > 0 THEN FACX.FECHA_VENCIMIENTO 
  ELSE ADD_MONTHS(FACX.FECHA_VENCIMIENTO ,1) 
  END FCHVCTO,
  REPA.FECHA_RECIBO AS FCHCOMP,
  REPA.VALOR_PAGADO AS IMPORTE,
  REPA.FECHA_CREACION AS MARCA,
  REPA.VALOR_PAGADO AS IMPMONDOC,
  REPA.MONEDA AS CODMONDOC,
  CASE WHEN REPA.DESCUENTO > 0 THEN 'D' ELSE 'C' END AS IND1,
  CAST (NULL AS VARCHAR(255)) IND2,
  CAST (NULL AS VARCHAR(255)) IND3,
  CAST (NULL AS VARCHAR(255)) IND4,
  CAST (NULL AS VARCHAR(255)) IND5,
  CAST (NULL AS VARCHAR(255)) IND6,
  CAST (NULL AS VARCHAR(255)) IND7,
  CAST (NULL AS VARCHAR(255)) IND8,
  CAST (NULL AS VARCHAR(255)) IND9,
  --CASE 
  --  WHEN CAED.CLASE_DOCUMENTO IS NOT NULL THEN CAED.CLASE_DOCUMENTO ELSE REPA.TIPO_DOCUMENTO END
  -- AS TDOC,
  FACX.TIPO_DOC AS TDOC,
  LPAD(REPA.ID_PEFAERP,10,'0') CAMPOID,
  TO_CHAR(FACX.FECHA_FACTURACION,'yyyy') AS CODEJERCICIO,
  TO_CHAR(REPA.FECHA_RECIBO,'yyyy') AS CODEJERCICIOCOMP,
  REPA.NUMERO_RECIBO AS NUMDOCCOBRO,
  CAST (NULL AS VARCHAR(64)) AS NUMDOCORIGEN,
  CAST (NULL AS VARCHAR(64)) AS CODVIAPAGO
  FROM SIMACMOBILE.CLIENTE_ERP CLIE
  JOIN SIMACMOBILE.RECIBO_PAGO_ERP REPA ON REPA.ID_CLERP = CLIE.ID_CLERP  
  LEFT JOIN SIMACMOBILE.FACTURA_CXC_ERP FACX ON FACX.ID_CLERP = CLIE.ID_CLERP 
  AND FACX.NUMERO_DOCUMENTO = REPA.NUMERO_FACTURA
  AND FACX.NUMERO_CUOTA = REPA.NUMERO_CUOTA
  --LEFT JOIN SIMACMOBILE.CARTERA_EDADES_ERP CAED ON CAED.NRO_ORACLE = REPA.NUMERO_RECIBO;

---

← Volver al esquema SIMACMOBILE

🏠 Volver al menú principal