View: JG_ZZ_TA_JE_LINES_V

Product:	JG - Regional Localizations
Description:
Implementation/DBA Data:	APPS.JG_ZZ_TA_JE_LINES_V

View Text

SELECT ALO.ROWID ALLOC_ROW_ID
, JLI.ROWID ROW_ID
, BAT.STATUS STATUS
, HDR.JE_BATCH_ID JE_BATCH_ID
, HDR.JE_HEADER_ID JE_HEADER_ID
, HDR.ACTUAL_FLAG ACTUAL_FLAG
, HDR.NAME JE_HEADER_NAME
, HDR.DOC_SEQUENCE_VALUE JE_DOC_SEQUENCE_VALUE
, HDR.EXTERNAL_REFERENCE EXTERNAL_REFERENCE
, SEQ.NAME JE_DOC_SEQUENCE_NAME
, HDR.BUDGET_VERSION_ID BUDGET_VERSION_ID
, HDR.ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID
, HDR.CURRENCY_CODE CURRENCY_CODE
, CONV.USER_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, HDR.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, HDR.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, HDR.PERIOD_NAME PERIOD_NAME
, BAT.NAME JE_BATCH_NAME
, JLI.JE_LINE_NUM JE_LINE_NUM
, JLI.EFFECTIVE_DATE EFFECTIVE_DATE
, JLI.ACCOUNTED_CR ACCOUNTED_CR
, JLI.ACCOUNTED_DR ACCOUNTED_DR
, JLI.ENTERED_CR ENTERED_CR
, JLI.ENTERED_DR ENTERED_DR
, JLI.LEDGER_ID LEDGER_ID
, JLI.STAT_AMOUNT STAT_AMOUNT
, JLI.SUBLEDGER_DOC_SEQUENCE_ID SUBLEDGER_DOC_SEQUENCE_ID
, JLI.SUBLEDGER_DOC_SEQUENCE_VALUE SUBLEDGER_DOC_SEQUENCE_VALUE
, JLI.INVOICE_DATE INVOICE_DATE
, JLI.TAX_CODE TAX_CODE
, JLI.INVOICE_IDENTIFIER INVOICE_IDENTIFIER
, JLI.INVOICE_AMOUNT INVOICE_AMOUNT
, JLI.USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, JLR.JGZZ_RECON_REF JGZZ_RECON_REF
, JLI.CONTEXT CONTEXT
, JLI.CONTEXT2 CONTEXT2
, JLI.CONTEXT3 CONTEXT3
, JLI.CONTEXT4 CONTEXT4
, JLI.ATTRIBUTE1 ATTRIBUTE1
, JLI.ATTRIBUTE2 ATTRIBUTE2
, JLI.ATTRIBUTE3 ATTRIBUTE3
, JLI.ATTRIBUTE4 ATTRIBUTE4
, JLI.ATTRIBUTE5 ATTRIBUTE5
, JLI.ATTRIBUTE6 ATTRIBUTE6
, JLI.ATTRIBUTE7 ATTRIBUTE7
, JLI.ATTRIBUTE8 ATTRIBUTE8
, JLI.ATTRIBUTE9 ATTRIBUTE9
, JLI.ATTRIBUTE10 ATTRIBUTE10
, JLI.ATTRIBUTE11 ATTRIBUTE11
, JLI.ATTRIBUTE12 ATTRIBUTE12
, JLI.ATTRIBUTE13 ATTRIBUTE13
, JLI.ATTRIBUTE14 ATTRIBUTE14
, JLI.ATTRIBUTE15 ATTRIBUTE15
, JLI.ATTRIBUTE16 ATTRIBUTE16
, JLI.ATTRIBUTE17 ATTRIBUTE17
, JLI.ATTRIBUTE18 ATTRIBUTE18
, JLI.ATTRIBUTE19 ATTRIBUTE19
, JLI.ATTRIBUTE20 ATTRIBUTE20
, GLC.CODE_COMBINATION_ID CODE_COMBINATION_ID
, GLC.ACCOUNT_TYPE ACCOUNT_TYPE
, GLC.SEGMENT1 SEGMENT1
, GLC.SEGMENT2 SEGMENT2
, GLC.SEGMENT3 SEGMENT3
, GLC.SEGMENT4 SEGMENT4
, GLC.SEGMENT5 SEGMENT5
, GLC.SEGMENT6 SEGMENT6
, GLC.SEGMENT7 SEGMENT7
, GLC.SEGMENT8 SEGMENT8
, GLC.SEGMENT9 SEGMENT9
, GLC.SEGMENT10 SEGMENT10
, GLC.SEGMENT11 SEGMENT11
, GLC.SEGMENT12 SEGMENT12
, GLC.SEGMENT13 SEGMENT13
, GLC.SEGMENT14 SEGMENT14
, GLC.SEGMENT15 SEGMENT15
, GLC.SEGMENT16 SEGMENT16
, GLC.SEGMENT17 SEGMENT17
, GLC.SEGMENT18 SEGMENT18
, GLC.SEGMENT19 SEGMENT19
, GLC.SEGMENT20 SEGMENT20
, GLC.SEGMENT21 SEGMENT21
, GLC.SEGMENT22 SEGMENT22
, GLC.SEGMENT23 SEGMENT23
, GLC.SEGMENT24 SEGMENT24
, GLC.SEGMENT25 SEGMENT25
, GLC.SEGMENT26 SEGMENT26
, GLC.SEGMENT27 SEGMENT27
, GLC.SEGMENT28 SEGMENT28
, GLC.SEGMENT29 SEGMENT29
, GLC.SEGMENT30 SEGMENT30
, ALO.REQUEST_ID REQUEST_ID
FROM GL_JE_BATCHES BAT
, GL_DAILY_CONVERSION_TYPES CONV
, FND_DOCUMENT_SEQUENCES SEQ
, GL_JE_HEADERS HDR
, GL_JE_LINES JLI
, GL_JE_LINES_RECON JLR
, GL_CODE_COMBINATIONS GLC
, JG_ZZ_TA_ALLOCATED_LINES ALO
WHERE HDR.JE_BATCH_ID = BAT.JE_BATCH_ID AND CONV.CONVERSION_TYPE = HDR.CURRENCY_CONVERSION_TYPE AND SEQ.DOC_SEQUENCE_ID(+) = HDR.DOC_SEQUENCE_ID
AND HDR.JE_HEADER_ID = JLI.JE_HEADER_ID
AND JLI.JE_HEADER_ID = JLR.JE_HEADER_ID(+)
AND JLI.JE_LINE_NUM = JLR.JE_LINE_NUM(+) AND JLI.CODE_COMBINATION_ID = GLC.CODE_COMBINATION_ID AND JLI.JE_HEADER_ID = ALO.JE_HEADER_ID(+) AND JLI.JE_LINE_NUM= ALO.JE_LINE_NUM(+)

Columns