🏠 Menú principal

← Volver a vistas simples

---

LACLS.LACLS_CO_PARTY_VALIDATIONS_BALANCES_V

Base de datos origen: PDB1

Tipo de objeto: VIEW

SQL

  CREATE OR REPLACE FORCE EDITIONABLE VIEW "LACLS"."LACLS_CO_PARTY_VALIDATIONS_BALANCES_V" ("NAME", "LEDGER_ID", "PERIOD_NAME", "PERIOD_STATUS", "EFFECTIVE_PERIOD_NUM", "STATUS", "TOT_HEADERS", "BALANCES") AS 
  SELECT
/* $Header: LACLS_CO_PARTY_VALIDATIONS_BALANCES_V.vw 11.1.1113.3 2023/28/06 20:37:15 JFORERO noship $ */
  "NAME","LEDGER_ID","PERIOD_NAME","PERIOD_STATUS","EFFECTIVE_PERIOD_NUM","STATUS","TOT_HEADERS","BALANCES"
FROM (
    SELECT
        l.name,
        l.ledger_id,
        p.period_name,
        p.period_status,
        p.effective_period_num,
        '**UNPOSTED**' status,
        COUNT(1) tot_headers,
        ' ' balances
    FROM
        LACLS_CO_GL_HEADERS_UNPOSTED   h,
        LACLS_CO_PERIODS      p,
        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
    GROUP BY
        l.name,
        l.ledger_id,
        p.period_name,
        p.period_status,
        p.effective_period_num
UNION ALL
    SELECT
        l.name,
        p.ledger_id,
        p.period_name,
        p.period_status,
        p.effective_period_num,
        h.status,
        COUNT(1) tot_headers,
        (
            SELECT
                decode(COUNT(1), 0, 'No', 'SI')
            FROM
                lacls_co_party_balances b
            WHERE
                b.period_name = p.period_name
                AND b.ledger_id = p.ledger_id
        ) balances
    FROM
        LACLS_CO_GL_HEADERS   h,
        LACLS_CO_PERIODS      p,
        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
    GROUP BY
        l.name,
        p.ledger_id,
        p.period_name,
        p.period_status,
        p.effective_period_num,
        h.status,
        p.effective_period_num)
    ORDER BY
        ledger_id,
        effective_period_num DESC;

---

← Volver al esquema LACLS

🏠 Volver al menú principal