🏠 Menú principal

← Volver a vistas materializadas

---

SIMACMOBILE.AXR_PARTABIERTAS

Base de datos origen: ORCLSMM

Tipo de objeto: MATERIALIZED VIEW

SQL

  CREATE MATERIALIZED VIEW "SIMACMOBILE"."AXR_PARTABIERTAS" ("CODSOCIEDAD", "CODCLI", "NDOC", "NVCTO", "FCHEMI", "FCHVCTO", "IMPORTE", "ESTADO", "DOTADA", "CODVP", "CODCONDP", "CODMONDOC", "IMPMONDOC", "IND1", "IND2", "IND3", "IND4", "IND5", "IND6", "IND7", "IND8", "IND9", "TDOC", "CAMPOID", "CODEJERCICIO", "NUMDOCORIGEN")
  SEGMENT CREATION IMMEDIATE
  ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  BUILD DEFERRED
  USING INDEX 
  REFRESH FORCE ON DEMAND
  USING DEFAULT LOCAL ROLLBACK SEGMENT
  USING ENFORCED CONSTRAINTS DISABLE ON QUERY COMPUTATION DISABLE QUERY REWRITE
  AS SELECT 
  '890300225' CODSOCIEDAD,
  FACX.SITE AS CODCLI,
  NVL(FACX.NUMERO_DOCUMENTO,0) AS NDOC,
  FACX.NUMERO_CUOTA NVCTO,
  FACX.FECHA_FACTURACION AS FCHEMI,
  TO_DATE(TO_CHAR(FACX.FECHA_VENCIMIENTO,'yyyy-mm-dd'),'yyyy-mm-dd') FCHVCTO,
  FACX.VALOR_SALDO AS IMPORTE,
  CASE WHEN SYSDATE > FACX.FECHA_VENCIMIENTO THEN 1
  	   ELSE 0 END AS ESTADO,
  0 AS DOTADA,
  CAST (NULL AS VARCHAR(64)) as CODVP,
  CAST (NULL AS VARCHAR(64)) as CODCONDP,
  'COP' AS CODMONDOC,
  FACX.VALOR_SALDO AS IMPMONDOC,
  CAST (NULL AS VARCHAR(255)) 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,
  FACX.TIPO_DOC AS TDOC,
  LPAD(FACX.ID_FACERP,10,'0')||'@#'|| CASE WHEN FACX.NUMERO_CUOTA = 0 THEN '00' ELSE LPAD(FACX.NUMERO_CUOTA,2,'0') END CAMPOID,
  TO_CHAR(FACX.FECHA_FACTURACION,'yyyy') AS CODEJERCICIO,
  CAST (NULL AS VARCHAR(64)) as NUMDOCORIGEN
  FROM SIMACMOBILE.FACTURA_CXC_ERP FACX
  WHERE FACX.VALOR_SALDO <> 0;

---

← Volver al esquema SIMACMOBILE

🏠 Volver al menú principal