🏠 Menú principal

← Volver a vistas simples

---

LACLS.LACLS_CO_TP_GL_OTHERS_V

Base de datos origen: PDB1

Tipo de objeto: VIEW

SQL

  CREATE OR REPLACE FORCE EDITIONABLE VIEW "LACLS"."LACLS_CO_TP_GL_OTHERS_V" ("PERIOD_NAME", "LEDGER_ID", "NAME", "COUNT_REG") AS 
  SELECT 
/* $Header: LACLS_CO_TP_GL_OTHERS_V.vw 11.1.1113.1 2021/30/12 12:03:38 JFORERO noship $ */
	  replace(replace(o.period_name, CHR(10)), CHR(13)) period_name
	, o.ledger_id
	, l.name
	, count(1) count_reg
from lacls_co_tp_gl_others o,
     lacls_co_gl_ledgers l
where o.ledger_id = l.ledger_id
  and replace(replace(o.period_name, CHR(10)), CHR(13)) is not null
group by replace(replace(o.period_name, CHR(10)), CHR(13)), o.ledger_id, l.name;

---

← Volver al esquema LACLS

🏠 Volver al menú principal