LACLS.LACLS_CO_PARTY_JOURNALS_V

Base de datos origen: PDB1
Tipo de objeto: VIEW
SQL

  CREATE OR REPLACE FORCE EDITIONABLE VIEW "LACLS"."LACLS_CO_PARTY_JOURNALS_V" ("JOURNAL_ID", "PERIOD_NAME", "LEDGER_ID", "PARTY_ID", "JE_SOURCE", "JE_CATEGORY", "SOURCE_ID", "BSV_VALUE", "ACCOUNT_NUMBER", "CODE_COMBINATION_ID", "ACCOUNT_CONCATENATED", "ACCOUNTING_DATE", "LINE_DESCRIPTION", "ACCOUNTED_DR", "ACCOUNTED_CR", "LINE_TYPE_LOOKUP_CODE", "GROSS_AMOUNT", "GL_SL_LINK_ID", "JE_HEADER_ID", "JE_LINE_NUM", "ADD_ATT1", "ADD_ATT2", "ADD_ATT3", "ADD_ATT4", "ADD_ATT5", "ADD_ATT6", "ADD_ATT7", "ADD_ATT8", "ADD_ATT9", "ADD_ATT10", "ADD_ATT11", "ADD_ATT12", "ADD_ATT13", "ADD_ATT14", "ADD_ATT15", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN") AS 
  SELECT lcp.JOURNAL_ID 
     , lcp.PERIOD_NAME  
     , lcp.LEDGER_ID  
     , lcp.PARTY_ID  
     , lcp.JE_SOURCE  
     , lcp.JE_CATEGORY 
     , lcp.SOURCE_ID 
     , lcp.BSV_VALUE 
     , lcp.ACCOUNT_NUMBER  
     , lcp.CODE_COMBINATION_ID 
     , lcg.CONCATENATED_SEGS account_concatenated
     , lcp.ACCOUNTING_DATE  
     , lcp.LINE_DESCRIPTION 
     , lcp.ACCOUNTED_DR  
     , lcp.ACCOUNTED_CR  
     , lcp.LINE_TYPE_LOOKUP_CODE  
     , lcp.GROSS_AMOUNT  
     , lcp.GL_SL_LINK_ID 
     , lcp.JE_HEADER_ID  
     , lcp.JE_LINE_NUM   
     , lcp.ADD_ATT1  
     , lcp.ADD_ATT2  
     , lcp.ADD_ATT3  
     , lcp.ADD_ATT4  
     , lcp.ADD_ATT5  
     , lcp.ADD_ATT6  
     , lcp.ADD_ATT7  
     , lcp.ADD_ATT8  
     , lcp.ADD_ATT9  
     , lcp.ADD_ATT10  
     , lcp.ADD_ATT11  
     , lcp.ADD_ATT12  
     , lcp.ADD_ATT13  
     , lcp.ADD_ATT14  
     , lcp.ADD_ATT15  
     , lcp.CREATION_DATE 
     , lcp.CREATED_BY    
     , lcp.LAST_UPDATE_DATE 
     , lcp.LAST_UPDATED_BY  
     , lcp.LAST_UPDATE_LOGIN 
  FROM LACLS_CO_PARTY_JOURNALS lcp
     , LACLS_CO_GL_CODE_COMBINATIONS lcg
WHERE lcp.CODE_COMBINATION_ID = lcg.CODE_COMBINATION_ID;
← Volver al esquema LACLS
🏠 Volver al menú principal