SELECT JEL.JE_HEADER_ID
,JEL.JE_LINE_NUM
,JEL.LAST_UPDATE_DATE
,JEL.LAST_UPDATED_BY
,JEL.LEDGER_ID
,JEL.CODE_COMBINATION_ID
,JEL.PERIOD_NAME
,JEL.STATUS
,JEL.CREATION_DATE
,JEL.CREATED_BY
,JEL.ENTERED_DR
,JEL.ENTERED_CR
,JEL.ACCOUNTED_DR
,JEL.ACCOUNTED_CR
,JEL.REFERENCE_1
,JEL.REFERENCE_2
,JEL.REFERENCE_3
,JEL.REFERENCE_4
,JEL.REFERENCE_5
,JEL.REFERENCE_6
,JEL.REFERENCE_7
,JEL.REFERENCE_8
,JEL.REFERENCE_9
,JEL.REFERENCE_10
,JEL.GL_SL_LINK_ID
,JEH.JE_CATEGORY
,JEH.JE_SOURCE
,JEH.NAME
,JEH.CURRENCY_CODE
,JEH.POSTED_DATE
,JEB.NAME
,PRDS.START_DATE
,PRDS.END_DATE
,GL.LEDGER_CATEGORY_CODE
,PRDS.ADJUSTMENT_PERIOD_FLAG
FROM GL_JE_LINES JEL
,GL_JE_HEADERS JEH
,GL_JE_BATCHES JEB
,GL_PERIOD_STATUSES PRDS
,GL_LEDGERS GL
WHERE JEL.JE_HEADER_ID = JEH.JE_HEADER_ID
AND JEH.ACTUAL_FLAG = 'A'
AND JEH.JE_BATCH_ID = JEB.JE_BATCH_ID (+)
AND JEL.PERIOD_NAME = PRDS.PERIOD_NAME
AND JEL.LEDGER_ID = PRDS.SET_OF_BOOKS_ID
AND JEL.LEDGER_ID = GL.LEDGER_ID
AND PRDS.APPLICATION_ID = 101
AND JEH.CURRENCY_CODE <> 'STAT'
AND JEB.STATUS = 'P'
No comments:
Post a Comment