Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a vistas simples |
LACLS.LACLS_CO_LINE_TYPES_V
Base de datos origen: PDB1
Tipo de objeto: VIEW
SQL
CREATE OR REPLACE FORCE EDITIONABLE VIEW "LACLS"."LACLS_CO_LINE_TYPES_V" ("JE_SOURCE", "JE_CATEGORY", "LINE_TYPE_LOOKUP_CODE") AS
SELECT
/* $Header: LACLS_CO_LINE_TYPES_V.vw 11.1.1113.2 2025/24/04 14:26:46 JFORERO noship $ */
DISTINCT je_source,
NULL je_category ,
-- je_category ,
line_type_lookup_code
from lacls_co_party_journals
where line_type_lookup_code IS NOT NULL
AND je_source <> all ('Assets',
'AutoCopy',
'Manual',
'Spreadsheet',
--'Receivables', --37834612
'Project Accounting',
'Revaluation');