Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a vistas simples |
LACLS.LACLS_CO_MM_REP_VAL_ACC_RAN_V
Base de datos origen: PDB1
Tipo de objeto: VIEW
SQL
CREATE OR REPLACE FORCE EDITIONABLE VIEW "LACLS"."LACLS_CO_MM_REP_VAL_ACC_RAN_V" ("REP_VALUE_RANGE_ID", "REP_VALUE_ID", "ACCOUNT_LOW", "ACCOUNT_HIGH", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "CONCATENATED_SEGS_LOW", "CONCATENATED_SEGS_HIGH", "APPLICATION_COLUMN_NAME", "SEGMENT_ATTRIBUTE_TYPE", "PARTY_ID", "NIT", "NAME") AS
SELECT
/* $Header: LACLS_CO_MM_REP_VAL_ACC_RAN_V.vw 11.1.1113.1 2025/09/06 15:52:51 JFORERO noship $ */
var."REP_VALUE_RANGE_ID",var."REP_VALUE_ID",var."ACCOUNT_LOW",var."ACCOUNT_HIGH",var."CREATION_DATE",var."CREATED_BY",var."LAST_UPDATE_DATE",var."LAST_UPDATED_BY",var."LAST_UPDATE_LOGIN",var."CONCATENATED_SEGS_LOW",var."CONCATENATED_SEGS_HIGH",var."APPLICATION_COLUMN_NAME",var."SEGMENT_ATTRIBUTE_TYPE",var."PARTY_ID",
tp.nit,tp.name
FROM lacls_co_mm_rep_val_acc_ran var,
lacls_co_third_party tp
WHERE var.party_id = tp.party_id(+);