Tuesday, 1 November 2011

Manual GL Query

SELECT   sob.NAME H_LEDGER_NAME,
         nvl(gjh.EXTERNAL_REFERENCE,'null') H_JOURNAL_REFERENCE,
         gjh.NAME H_JOURNAL_NAME,
         gjh.DATE_CREATED H_JOURNAL_DATE,
         gjh.CURRENCY_CODE H_CURRENCY_CODE,
         gjh.CURRENCY_CONVERSION_DATE H_CURRENCY_CONVERSION_DATE,
         gjh.CURRENCY_CONVERSION_TYPE H_CURRENCY_CONVERSION_TYPE,
         gjh.CURRENCY_CONVERSION_RATE H_CURRENCY_CONVERSION_RATE,
         gjh.JE_CATEGORY H_JOURNAL_CATEGORY,
         gjh.JE_SOURCE H_JOURNAL_SOURCE,
         gjl.JE_LINE_NUM L_LINE_NUMBER,
         gjl.ACCOUNTED_dr ACCOUNTED_CR,
         gjl.ACCOUNTED_CR L_CREDIT_AMOUNT,
         kfv.CONCATENATED_SEGMENTS,
         gjl.DESCRIPTION
  FROM   gl_je_headers gjh,
         gl_je_lines gjl,
         GL_CODE_COMBINATIONS_KFV KFV,
         gl_sets_of_books sob
 WHERE       gjh.JE_HEADER_ID = gjl.JE_HEADER_ID
         AND gjl.CODE_COMBINATION_ID = kfv.CODE_COMBINATION_ID
         AND sob.SET_OF_BOOKS_ID = gjh.SET_OF_BOOKS_ID
         AND gjh.JE_SOURCE = 'Manual'
         AND TRUNC (gjh.DATE_CREATED) BETWEEN '01-APR-2011' AND '31-MAY-2011'
         AND GJH.SET_OF_BOOKS_ID = 5

No comments:

Post a Comment