View: GL_JE_LINES_RECON_V

Product:	GL - General Ledger
Description:
Implementation/DBA Data:	APPS.GL_JE_LINES_RECON_V

View Text

SELECT L.ROWID ROW_ID
, R.ROWID RECON_ROW_ID
, B.NAME BATCH_NAME
, H.JE_HEADER_ID JE_HEADER_ID
, JC.USER_JE_CATEGORY_NAME JE_CATEGORY
, JS.USER_JE_SOURCE_NAME JE_SOURCE
, H.NAME JE_NAME
, H.CURRENCY_CODE CURRENCY_CODE
, H.DESCRIPTION JE_DESCRIPTION
, H.EXTERNAL_REFERENCE JE_REFERENCE
, H.DOC_SEQUENCE_ID SEQUENCE_ID
, H.DOC_SEQUENCE_VALUE SEQUENCE_VALUE
, S.NAME SEQUENCE_NAME
, R.LEDGER_ID LEDGER_ID
, L.STATUS STATUS
, L.EFFECTIVE_DATE EFFECTIVE_DATE
, L.JE_LINE_NUM JE_LINE_NUM
, L.CODE_COMBINATION_ID CODE_COMBINATION_ID
, L.ENTERED_DR ENTERED_DR
, L.ENTERED_CR ENTERED_CR
, L.ACCOUNTED_DR ACCOUNTED_DR
, L.ACCOUNTED_CR ACCOUNTED_CR
, L.DESCRIPTION DESCRIPTION
, L.PERIOD_NAME PERIOD_NAME
, L.CREATION_DATE CREATION_DATE
, L.CREATED_BY CREATED_BY
, L.LAST_UPDATE_DATE LAST_UPDATE_DATE
, L.LAST_UPDATED_BY LAST_UPDATED_BY
, L.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PS.EFFECTIVE_PERIOD_NUM EFFECTIVE_PERIOD_NUM
, R.JGZZ_RECON_STATUS JGZZ_RECON_STATUS
, R.JGZZ_RECON_DATE JGZZ_RECON_DATE
, R.JGZZ_RECON_ID JGZZ_RECON_ID
, R.JGZZ_RECON_REF JGZZ_RECON_REF
, C.SEGMENT1 SEGMENT1
, C.SEGMENT2 SEGMENT2
, C.SEGMENT3 SEGMENT3
, C.SEGMENT4 SEGMENT4
, C.SEGMENT5 SEGMENT5
, C.SEGMENT6 SEGMENT6
, C.SEGMENT7 SEGMENT7
, C.SEGMENT8 SEGMENT8
, C.SEGMENT9 SEGMENT9
, C.SEGMENT10 SEGMENT10
, C.SEGMENT11 SEGMENT11
, C.SEGMENT12 SEGMENT12
, C.SEGMENT13 SEGMENT13
, C.SEGMENT14 SEGMENT14
, C.SEGMENT15 SEGMENT15
, C.SEGMENT16 SEGMENT16
, C.SEGMENT17 SEGMENT17
, C.SEGMENT18 SEGMENT18
, C.SEGMENT19 SEGMENT19
, C.SEGMENT20 SEGMENT20
, C.SEGMENT21 SEGMENT21
, C.SEGMENT22 SEGMENT22
, C.SEGMENT23 SEGMENT23
, C.SEGMENT24 SEGMENT24
, C.SEGMENT25 SEGMENT25
, C.SEGMENT26 SEGMENT26
, C.SEGMENT27 SEGMENT27
, C.SEGMENT28 SEGMENT28
, C.SEGMENT29 SEGMENT29
, C.SEGMENT30 SEGMENT30
FROM GL_JE_BATCHES B
, GL_JE_HEADERS H
, GL_JE_LINES L
, GL_CODE_COMBINATIONS C
, GL_JE_LINES_RECON R
, FND_DOCUMENT_SEQUENCES S
, GL_JE_SOURCES JS
, GL_JE_CATEGORIES JC
, GL_PERIOD_STATUSES PS
WHERE B.JE_BATCH_ID = H.JE_BATCH_ID
AND H.JE_HEADER_ID = L.JE_HEADER_ID
AND L.CODE_COMBINATION_ID = C.CODE_COMBINATION_ID
AND L.JE_HEADER_ID = R.JE_HEADER_ID
AND L.JE_LINE_NUM = R.JE_LINE_NUM
AND H.JE_SOURCE = JS.JE_SOURCE_NAME
AND H.JE_CATEGORY = JC.JE_CATEGORY_NAME
AND H.DOC_SEQUENCE_ID = S.DOC_SEQUENCE_ID(+)
AND H.PERIOD_NAME = PS.PERIOD_NAME
AND PS.LEDGER_ID = H.LEDGER_ID
AND PS.APPLICATION_ID = 101
AND L.STATUS = 'P'
AND C.JGZZ_RECON_FLAG = 'Y'
AND H.ACTUAL_FLAG = 'A'

Columns