SELECT TAX JOURNALS

SELECT TAX JOURNALS

SELECT

GLJH.JE_HEADER_ID "HID",

GLJH.TAX_STATUS_CODE "TC",

GLJL.TAX_CODE_ID "ID",

TO_CHAR(GLJH.LAST_UPDATE_DATE,'DD-MON-YYYY') "UPDATE_DATE"

FROM GL_JE_HEADERS GLJH,

GL_JE_LINES GLJL,

GL_CODE_COMBINATIONS GLCC,

GL_JE_BATCHES GLJB

WHERE

GLJH.JE_HEADER_ID=GLJL.JE_HEADER_ID AND

GLJL.CODE_COMBINATION_ID=GLCC.CODE_COMBINATION_ID AND

GLJH.JE_BATCH_ID=GLJB.JE_BATCH_ID AND

GLJH.TAX_STATUS_CODE='T'

order by GLJH.JE_HEADER_ID;