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