🏠 Menú principal

← Volver a vistas simples

---

LACLS.LACLS_CO_PARTY_VALIDATIONS_PROCESS_V

Base de datos origen: PDB1

Tipo de objeto: VIEW

SQL

  CREATE OR REPLACE FORCE EDITIONABLE VIEW "LACLS"."LACLS_CO_PARTY_VALIDATIONS_PROCESS_V" ("NAME", "LEDGER_ID", "PERIOD_NAME", "EFFECTIVE_PERIOD_NUM", "STATUS", "JE_SOURCE", "JE_CATEGORY", "TOTAL_HEADERS") AS 
  SELECT
/* $Header: LACLS_CO_PARTY_VALIDATIONS_PROCESS_V.vw 11.1.1113.1 2020/18/04 01:09:00 JFORERO noship $ */
        l.name,
        h.ledger_id,
        h.period_name,
        p.effective_period_num,
        h.status,
        h.je_source,
        h.je_category,
        COUNT(1) total_headers
    FROM
        lacls.lacls_co_gl_headers   h,
        lacls.lacls_co_periods      p,
        lacls.lacls_co_gl_ledgers   l
    WHERE
        p.period_name = h.period_name
        AND p.ledger_id = h.ledger_id
        AND l.ledger_id = h.ledger_id
--AND h.status <> 'PROCESSED'
    GROUP BY
        l.name,
        h.ledger_id,
        h.period_name,
        p.effective_period_num,
        h.status,
        h.je_source,
        h.je_category,
        p.effective_period_num
    ORDER BY
        h.ledger_id,
        p.effective_period_num;

---

← Volver al esquema LACLS

🏠 Volver al menú principal