Follow us: Subscribe via RSS Feed Connect on YouTube Connect on YouTube

Pages

Sunday, 5 February 2017

Query to Find GL Journal Line Based On Trial Balance

SELECT gld.short_name, gld.NAME, gjh.NAME je_name,
       gjl.description "DESCRIPTION LINE",
       gjh.doc_sequence_value "DOCUMENT NUMBER",
      
       --VERSION 2.04 CHANGES,ADDED COLUMN--
       DECODE (gjh.accrual_rev_status,
               '', 'NON REVERSED',
               'REVERSED'
              ) "STATUS",                --VERSION 2.04 CHANGES,ADDED COLUMN--
          gcc.segment1
       || '-'
       || gcc.segment2
       || '-'
       || gcc.segment3
       || '-'
       || gcc.segment4 "ACCOUNT",
       gcc.segment1, gcc.segment2, gcc.segment3, gcc.segment4,
      
       ----VERSION 2.04 CHANGES,REMOVED AGGREGATE FUNCTION----
       gjl.accounted_dr "DR", gjl.accounted_cr "CR",
       NVL (gjl.accounted_dr, 0) - NVL (gjl.accounted_cr, 0) "END BALANCE",
       gjl.period_name
  FROM gl_je_lines gjl,
       gl_je_headers gjh,
       gl_code_combinations gcc,
       gl_ledgers gld
 WHERE gjl.code_combination_id = gcc.code_combination_id
   AND gjl.je_header_id = gjh.je_header_id
   AND gld.ledger_id = gjh.ledger_id
--     AND GJL.PERIOD_NAME = 'DEC-05'                              --PERIOD NAME
--GROUP BY GLD.SHORT_NAME,
--         GLD.NAME,
--         GJH.NAME,
--         GJL.DESCRIPTION,
--            GCC.SEGMENT1
--         || '-'
--         || GCC.SEGMENT2
--         || '-'
--         || GCC.SEGMENT3
--         || '-'
--         || GCC.SEGMENT4,
--         GCC.SEGMENT1,
--         GCC.SEGMENT2,
--         GCC.SEGMENT3,
--         GCC.SEGMENT4,

--         GJL.PERIOD_NAME, GJH.DOC_SEQUENCE_VALUE,GJH.ACCRUAL_REV_STATUS;
Share this article :

0 comments:

Post a Comment