Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a vistas simples |
LACLS.LACLS_CO_PARTY_PARAMS_JOURNALS_V
Base de datos origen: PDB1
Tipo de objeto: VIEW
SQL
CREATE OR REPLACE FORCE EDITIONABLE VIEW "LACLS"."LACLS_CO_PARTY_PARAMS_JOURNALS_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 "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"
/* $Header: LACLS_CO_PARTY_PARAMS_JOURNALS_V.vw 11.1.1113.2 2021/29/04 12:56:29 JFORERO noship $ */
FROM lacls_co_party_params_periods_v p
WHERE p.name_flow = 'LACLS_CO_HEADERS'
AND p.enabled_flag = 'Y'
ORDER BY ledger_name,
effective_period_num;