View: GL_JE_LINES_V

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

View Text

SELECT JEL.ROWID ROW_ID
, JEL.JE_HEADER_ID JE_HEADER_ID
, JEL.JE_LINE_NUM JE_LINE_NUM
, JEL.CODE_COMBINATION_ID CODE_COMBINATION_ID
, JEL.ENTERED_DR ENTERED_DR
, JEL.ENTERED_CR ENTERED_CR
, JEL.ACCOUNTED_DR ACCOUNTED_DR
, JEL.ACCOUNTED_CR ACCOUNTED_CR
, JEL.DESCRIPTION DESCRIPTION
, JEL.STAT_AMOUNT STAT_AMOUNT
, JEL.USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, JEL.LEDGER_ID LEDGER_ID
, JEL.PERIOD_NAME PERIOD_NAME
, JEL.EFFECTIVE_DATE EFFECTIVE_DATE
, JEL.STATUS STATUS
, JEL.IGNORE_RATE_FLAG IGNORE_RATE_FLAG
, JEL.REFERENCE_1 REFERENCE_1
, JEL.REFERENCE_2 REFERENCE_2
, JEL.REFERENCE_3 REFERENCE_3
, JEL.REFERENCE_4 REFERENCE_4
, JEL.REFERENCE_5 REFERENCE_5
, JEL.REFERENCE_6 REFERENCE_6
, JEL.REFERENCE_7 REFERENCE_7
, JEL.REFERENCE_8 REFERENCE_8
, JEL.REFERENCE_9 REFERENCE_9
, JEL.REFERENCE_10 REFERENCE_10
, JEL.CONTEXT CONTEXT
, JEL.ATTRIBUTE1 ATTRIBUTE1
, JEL.ATTRIBUTE2 ATTRIBUTE2
, JEL.ATTRIBUTE3 ATTRIBUTE3
, JEL.ATTRIBUTE4 ATTRIBUTE4
, JEL.ATTRIBUTE5 ATTRIBUTE5
, JEL.ATTRIBUTE6 ATTRIBUTE6
, JEL.ATTRIBUTE7 ATTRIBUTE7
, JEL.ATTRIBUTE8 ATTRIBUTE8
, JEL.ATTRIBUTE9 ATTRIBUTE9
, JEL.ATTRIBUTE10 ATTRIBUTE10
, JEL.CONTEXT3 CONTEXT3
, JEL.ATTRIBUTE11 ATTRIBUTE11
, JEL.ATTRIBUTE12 ATTRIBUTE12
, JEL.ATTRIBUTE13 ATTRIBUTE13
, JEL.ATTRIBUTE14 ATTRIBUTE14
, JEL.ATTRIBUTE15 ATTRIBUTE15
, JEL.ATTRIBUTE16 ATTRIBUTE16
, JEL.ATTRIBUTE17 ATTRIBUTE17
, JEL.ATTRIBUTE18 ATTRIBUTE18
, JEL.ATTRIBUTE19 ATTRIBUTE19
, JEL.ATTRIBUTE20 ATTRIBUTE20
, JEL.CONTEXT2 CONTEXT2
, JEL.INVOICE_DATE INVOICE_DATE
, JEL.TAX_CODE TAX_CODE
, JEL.INVOICE_IDENTIFIER INVOICE_IDENTIFIER
, JEL.INVOICE_AMOUNT INVOICE_AMOUNT
, JEL.NO1 NO1
, JEL.CONTEXT4 CONTEXT4
, REC.ROWID RECON_ROWID
, NVL(REC.JGZZ_RECON_STATUS
, 'U') JGZZ_RECON_STATUS
, REC.JGZZ_RECON_DATE JGZZ_RECON_DATE
, REC.JGZZ_RECON_ID JGZZ_RECON_ID
, DECODE(USE.RECONCILIATION_UPG_FLAG
, 'Y'
, REC.JGZZ_RECON_REF
, DECODE (REC.ROWID
, NULL
, JEL.JGZZ_RECON_REF_11I
, REC.JGZZ_RECON_REF)) JGZZ_RECON_REF
, JEL.TAXABLE_LINE_FLAG TAXABLE_LINE_FLAG
, JEL.TAX_TYPE_CODE TAX_TYPE_CODE
, JEL.TAX_CODE_ID TAX_CODE_ID
, JEL.TAX_ROUNDING_RULE_CODE TAX_ROUNDING_RULE_CODE
, JEL.AMOUNT_INCLUDES_TAX_FLAG AMOUNT_INCLUDES_TAX_FLAG
, JEL.TAX_DOCUMENT_IDENTIFIER TAX_DOCUMENT_IDENTIFIER
, JEL.TAX_DOCUMENT_DATE TAX_DOCUMENT_DATE
, JEL.TAX_CUSTOMER_NAME TAX_CUSTOMER_NAME
, JEL.TAX_CUSTOMER_REFERENCE TAX_CUSTOMER_REFERENCE
, JEL.TAX_REGISTRATION_NUMBER TAX_REGISTRATION_NUMBER
, JEL.TAX_LINE_FLAG TAX_LINE_FLAG
, JEL.TAX_GROUP_ID TAX_GROUP_ID
, JEL.SUBLEDGER_DOC_SEQUENCE_ID SUBLEDGER_DOC_SEQUENCE_ID
, JEL.SUBLEDGER_DOC_SEQUENCE_VALUE SUBLEDGER_DOC_SEQUENCE_VALUE
, JEL.CO_THIRD_PARTY THIRD_PARTY_ID
, JEL.CREATION_DATE CREATION_DATE
, JEL.CREATED_BY CREATED_BY
, JEL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, JEL.LAST_UPDATED_BY LAST_UPDATED_BY
, JEL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CC.SEGMENT1 SEGMENT1
, CC.SEGMENT2 SEGMENT2
, CC.SEGMENT3 SEGMENT3
, CC.SEGMENT4 SEGMENT4
, CC.SEGMENT5 SEGMENT5
, CC.SEGMENT6 SEGMENT6
, CC.SEGMENT7 SEGMENT7
, CC.SEGMENT8 SEGMENT8
, CC.SEGMENT9 SEGMENT9
, CC.SEGMENT10 SEGMENT10
, CC.SEGMENT11 SEGMENT11
, CC.SEGMENT12 SEGMENT12
, CC.SEGMENT13 SEGMENT13
, CC.SEGMENT14 SEGMENT14
, CC.SEGMENT15 SEGMENT15
, CC.SEGMENT16 SEGMENT16
, CC.SEGMENT17 SEGMENT17
, CC.SEGMENT18 SEGMENT18
, CC.SEGMENT19 SEGMENT19
, CC.SEGMENT20 SEGMENT20
, CC.SEGMENT21 SEGMENT21
, CC.SEGMENT22 SEGMENT22
, CC.SEGMENT23 SEGMENT23
, CC.SEGMENT24 SEGMENT24
, CC.SEGMENT25 SEGMENT25
, CC.SEGMENT26 SEGMENT26
, CC.SEGMENT27 SEGMENT27
, CC.SEGMENT28 SEGMENT28
, CC.SEGMENT29 SEGMENT29
, CC.SEGMENT30 SEGMENT30
FROM GL_JE_LINES JEL
, GL_CODE_COMBINATIONS CC
, GL_JE_LINES_RECON REC
, GL_SYSTEM_USAGES USE
WHERE CC.CODE_COMBINATION_ID(+) = JEL.CODE_COMBINATION_ID
AND REC.JE_HEADER_ID(+) = JEL.JE_HEADER_ID
AND REC.JE_LINE_NUM(+) = JEL.JE_LINE_NUM

Columns