🏠 Menú principal

← Volver a vistas simples

---

LACLS.LACLS_CO_PARTY_PARAMS_PERIODS_V

Base de datos origen: PDB1

Tipo de objeto: VIEW

SQL

  CREATE OR REPLACE FORCE EDITIONABLE VIEW "LACLS"."LACLS_CO_PARTY_PARAMS_PERIODS_V" ("NAME_FLOW", "LEDGER_ID", "LEDGER_NAME", "HEADER_ROW_NUM", "PERIOD_NAME", "PERIOD_START_DATE", "PERIOD_END_DATE", "EFFECTIVE_PERIOD_NUM", "START_DATE", "END_DATE", "ENABLED_FLAG", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE", "LAST_UPDATED_BY", "PERIOD_NAME_FROM", "PERIOD_NAME_TO", "EFFECTIVE_PERIOD_NUM_FROM", "PERIOD_STATUS_FROM", "EFFECTIVE_PERIOD_NUM_TO", "PERIOD_STATUS_TO") AS 
  SELECT
/* $Header: LACLS_CO_PARTY_PARAMS_PERIODS_V.vw 11.1.1113.2 2021/29/04 12:49:19 JFORERO noship $ */
        p.name_flow,
        p.ledger_id,
        l.name ledger_name,
        ROW_NUMBER()OVER (PARTITION BY p.name_flow, p.ledger_id ORDER BY p.effective_period_num) AS Header_Row_num,
        p.period_name,
        p.period_start_date,
        p.period_end_date,
        p.effective_period_num,
--        party_params_id,
        p.start_date,
        p.end_date,
        p.enabled_flag,
        p.creation_date,
        p.created_by,
        p.last_update_date,
        p.last_updated_by,
        p.period_name_from,
        p.period_name_to,
        p.effective_period_num_from,
        p.period_status_from,
        p.effective_period_num_to,
        p.period_status_to
    FROM
        (
            SELECT
                per.period_name,
                per.effective_period_num,
                per.start_date period_start_date,
                per.end_date   period_end_date,
                pp.*
            FROM
                lacls_co_party_params_v   pp,
                lacls_co_periods          per
            WHERE
                1 = 1
                AND per.effective_period_num BETWEEN pp.effective_period_num_from AND pp.effective_period_num_to
                AND trunc(sysdate) BETWEEN pp.start_date AND nvl(pp.end_date, sysdate)
                AND pp.ledger_id = per.ledger_id
            UNION ALL
            SELECT
                per.period_name,
                per.effective_period_num,
                per.start_date period_start_date,
                per.end_date   period_end_date,
                pp.*
            FROM
                lacls_co_party_params_v   pp,
                lacls_co_periods          per
            WHERE
                1 = 1
                AND per.effective_period_num > pp.effective_period_num_from
                AND pp.effective_period_num_to IS NULL
                AND trunc(sysdate) BETWEEN pp.start_date AND nvl(pp.end_date, sysdate)
                AND pp.ledger_id = per.ledger_id
        ) p,
        lacls_co_gl_ledgers l
    WHERE p.ledger_id = l.ledger_id
    ORDER BY
        p.name_flow,
        l.name,
        p.effective_period_num;

---

← Volver al esquema LACLS

🏠 Volver al menú principal