Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
I have these queries this for accounting detail SELECT GJB.NAME AS LOTE_DE_ASIENTO, GJH.NAME AS ASIENTO, GJB.DEFAULT_PERIOD_NAME AS PERIODO_CONTABLE, GLE.NAME AS LIBRO_MAYOR, XEP.NAME AS ENTIDAD_JURIDICA, TO_CHAR(GJH.DEFAULT_EFFECTIVE_DATE-6/24,'DD-MM-YYYY hh24:mi:ss') AS FECHA_CONTABLE, --GJC.DESCRIPTION AS CATEGORIA,…