🏠 Menú principal

← Volver a vistas simples

---

LACLS.LACLS_CO_MM_FORMATS_ACC

Base de datos origen: PDB1

Tipo de objeto: VIEW

SQL

  CREATE OR REPLACE FORCE EDITIONABLE VIEW "LACLS"."LACLS_CO_MM_FORMATS_ACC" ("COMPANY_CODE", "COMPANY_NAME", "REPORTED_YEAR", "FORMAT_CODE", "FORMAT_DESCRIPTION", "CONCEPT_CODE", "CONCEPT_DESCRIPTION", "CON_THRESHOLD_VALUE", "THRESHOLD_EXCLUDE_FLAG", "REPORTED_VALUE", "VALUE_DESCRIPTION", "MOVEMENT_TYPE", "ACCOUNT_LOW", "ACCOUNT_HIGH", "CONCATENATED_SEGS_LOW", "CONCATENATED_SEGS_HIGH") AS 
  select 
/* $Header: LACLS_CO_MM_FORMATS_ACC.vw 11.1.1113.1 2020/28/10 12:19:30 JFORERO noship $ */
       c.company_code, 
       c.company_name,
       f.reported_year,
       f.format_code,
       f.description format_description,
       con.concept_code,
       con.description concept_description,
       con.threshold_value con_threshold_value ,
       con.threshold_exclude_flag,
       v.reported_value,
       v.description value_description,
       v.movement_type,
       acc.account_low,
       acc.account_high,
       acc.concatenated_segs_low,
       acc.concatenated_segs_high
from lacls_co_mm_company  c,
     lacls_co_mm_formats f,
     lacls_co_mm_concepts con,
     lacls_co_mm_reported_values v,
     lacls_co_mm_rep_val_acc_ran acc
where c.company_id = f.company_id
  and f.format_id = con.format_id
  and con.concept_id = v.concept_id
  and v.rep_value_id = acc.rep_value_id
order by c.company_code, 
       f.reported_year,
       f.format_code,
       con.concept_code,
       v.reported_value;

---

← Volver al esquema LACLS

🏠 Volver al menú principal