🏠 Menú principal

← Volver a vistas simples

---

LACLS.LACLS_CO_PARTY_VALIDATIONS_ERROR_V

Base de datos origen: PDB1

Tipo de objeto: VIEW

SQL

  CREATE OR REPLACE FORCE EDITIONABLE VIEW "LACLS"."LACLS_CO_PARTY_VALIDATIONS_ERROR_V" ("NAME", "LEDGER_ID", "PERIOD_NAME", "EFFECTIVE_PERIOD_NUM", "STATUS", "JE_SOURCE", "JE_CATEGORY", "JE_HEADER_ID", "H_ACCOUNTED_DR", "H_ACCOUNTED_CR", "H_LINE", "L_LINE", "L_ACCOUNTED_DR", "L_ACCOUNTED_CR") AS 
  SELECT
/* $Header: LACLS_CO_PARTY_VALIDATIONS_ERROR_V.vw 11.1.1113.1 2020/18/04 01:11:00 JFORERO noship $ */
        l.name,
        h.ledger_id,
        h.period_name,
        p.effective_period_num,
        h.status,
        h.je_source,
        h.je_category,
        h.je_header_id,
        h.running_total_accounted_dr   h_accounted_dr,
        h.running_total_accounted_cr   h_accounted_cr,
--    h.add_att5, 
--    h.add_att6, 
        h.add_att7                     h_line,
        COUNT(DISTINCT j.je_line_num) l_line,
        SUM(nvl(j.accounted_dr, 0)) l_accounted_dr,
        SUM(nvl(j.accounted_cr, 0)) l_accounted_cr
    FROM
        lacls_co_gl_headers         h,
        lacls.lacls_co_periods      p,
        lacls.lacls_co_gl_ledgers   l,
        lacls_co_party_journals     j
    WHERE
        1 = 1
        AND p.period_name = h.period_name
        AND p.ledger_id = h.ledger_id
        AND h.je_header_id = j.je_header_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,
        h.je_header_id,
        h.running_total_accounted_dr,
        h.running_total_accounted_cr,
        h.add_att5,
        h.add_att6,
        h.add_att7
    ORDER BY
        h.ledger_id,
        p.effective_period_num;

---

← Volver al esquema LACLS

🏠 Volver al menú principal