LACLS.LACLS_CO_PARTY_BALANCES_V

Base de datos origen: PDB1

Tipo de objeto: VIEW

SQL

  CREATE OR REPLACE FORCE EDITIONABLE VIEW "LACLS"."LACLS_CO_PARTY_BALANCES_V" ("BALANCE_ID", "PERIOD_NAME", "LEDGER_ID", "PARTY_ID", "BSV_VALUE", "ACCOUNT_NUMBER", "ACCOUNT_CONCATENATED", "BEGIN_BALANCE", "ACCOUNTED_DR", "ACCOUNTED_CR", "END_BALANCE", "CODE_COMBINATION_ID", "SOURCE", "THIRD_PARTY_NIT_SOURCE", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "ACCOUNT_DESC") AS 
  SELECT 
/* $Header: LACLS_CO_PARTY_BALANCES_V.vw 11.1.1113.2 2021/31/05 13:10:40 JFORERO noship $ */
       lcp.BALANCE_ID
     , lcp.PERIOD_NAME
     , lcp.LEDGER_ID
     , lcp.PARTY_ID
     , lcp.BSV_VALUE
     , lcp.ACCOUNT_NUMBER
     , lcg.CONCATENATED_SEGS account_concatenated
     , lcp.BEGIN_BALANCE
     , lcp.ACCOUNTED_DR
     , lcp.ACCOUNTED_CR
     , lcp.END_BALANCE
     , lcp.CODE_COMBINATION_ID
     , lcp.SOURCE
     , lcp.THIRD_PARTY_NIT_SOURCE
     , lcp.CREATION_DATE
     , lcp.CREATED_BY
     , lcp.LAST_UPDATE_DATE
     , lcp.LAST_UPDATED_BY
     , lcp.LAST_UPDATE_LOGIN
     , lcg.account_desc
  FROM LACLS_CO_PARTY_BALANCES lcp
     , LACLS_CO_GL_CODE_COMBINATIONS lcg
WHERE lcp.CODE_COMBINATION_ID = lcg.CODE_COMBINATION_ID;

← Volver al esquema LACLS

🏠 Volver al menú principal