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
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