🏠 Menú principal

← Volver a vistas simples

---

LACLS.LACLS_CO_PARTY_PARAMS_V

Base de datos origen: PDB1

Tipo de objeto: VIEW

SQL

  CREATE OR REPLACE FORCE EDITIONABLE VIEW "LACLS"."LACLS_CO_PARTY_PARAMS_V" ("PARTY_PARAMS_ID", "NAME_FLOW", "LEDGER_ID", "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
        pp.party_params_id,
        pp.name_flow,
        pp.ledger_id,
    --pp.period_name,
        pp.start_date,
        pp.end_date,
        pp.enabled_flag,
        pp.creation_date,
        pp.created_by,
        pp.last_update_date,
        pp.last_updated_by,
        pp.period_name_from,
        pp.period_name_to,
        per_from.effective_period_num   effective_period_num_from,
        per_from.period_status          period_status_from,
        per_to.effective_period_num     effective_period_num_to,
        per_to.period_status            period_status_to
    FROM
        lacls_co_party_params   pp,
        lacls_co_periods        per_from,
        lacls_co_periods        per_to
    WHERE
        1 = 1
        AND pp.period_name_from = per_from.period_name
        AND pp.ledger_id = per_from.ledger_id
        AND pp.period_name_to = per_to.period_name (+)
        AND pp.ledger_id = per_to.ledger_id (+)
    ORDER BY
        pp.name_flow,
        pp.ledger_id,
        per_from.effective_period_num;

---

← Volver al esquema LACLS

🏠 Volver al menú principal