View: GL_JE_JOURNAL_LINES_V

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

View Text

SELECT B.ROWID BATCH_ROW_ID
, B.JE_BATCH_ID JE_BATCH_ID
, H.LEDGER_ID LEDGER_ID
, B.DEFAULT_PERIOD_NAME PERIOD_NAME
, PS.PERIOD_YEAR PERIOD_YEAR
, PS.PERIOD_NUM PERIOD_NUM
, PS.EFFECTIVE_PERIOD_NUM EFFECTIVE_PERIOD_NUM
, B.ACTUAL_FLAG ACTUAL_FLAG
, B.STATUS BATCH_STATUS
, B.BUDGETARY_CONTROL_STATUS BUDGETARY_CONTROL_STATUS
, B.NAME BATCH_NAME
, B.DESCRIPTION BATCH_DESCRIPTION
, B.DATE_CREATED BATCH_DATE_CREATED
, B.POSTED_DATE BATCH_POSTED_DATE
, B.USSGL_TRANSACTION_CODE BATCH_USSGL_TRANSACTION_CODE
, B.CONTROL_TOTAL BATCH_CONTROL_TOTAL
, B.RUNNING_TOTAL_DR BATCH_RUNNING_TOTAL_DR
, B.RUNNING_TOTAL_CR BATCH_RUNNING_TOTAL_CR
, DECODE ( LR.RELATIONSHIP_TYPE_CODE
, 'BALANCE'
, NULL
, B.RUNNING_TOTAL_ACCOUNTED_DR ) BATCH_RUN_TOTAL_ACCOUNTED_DR
, DECODE ( LR.RELATIONSHIP_TYPE_CODE
, 'BALANCE'
, NULL
, B.RUNNING_TOTAL_ACCOUNTED_CR ) BATCH_RUN_TOTAL_ACCOUNTED_CR
, B.STATUS_VERIFIED BATCH_STATUS_VERIFIED
, B.DEFAULT_EFFECTIVE_DATE BATCH_EFFECTIVE_DATE
, B.STATUS_RESET_FLAG BATCH_STATUS_RESET_FLAG
, B.UNIQUE_DATE BATCH_UNIQUE_DATE
, B.EARLIEST_POSTABLE_DATE BATCH_EARLIEST_POSTABLE_DATE
, B.PACKET_ID PACKET_ID
, B.UNRESERVATION_PACKET_ID UNRESERVATION_PACKET_ID
, B.POSTING_RUN_ID POSTING_RUN_ID
, B.REQUEST_ID REQUEST_ID
, B.ATTRIBUTE1 BATCH_ATTRIBUTE1
, B.ATTRIBUTE2 BATCH_ATTRIBUTE2
, B.ATTRIBUTE3 BATCH_ATTRIBUTE3
, B.ATTRIBUTE4 BATCH_ATTRIBUTE4
, B.ATTRIBUTE5 BATCH_ATTRIBUTE5
, B.ATTRIBUTE6 BATCH_ATTRIBUTE6
, B.ATTRIBUTE7 BATCH_ATTRIBUTE7
, B.ATTRIBUTE8 BATCH_ATTRIBUTE8
, B.ATTRIBUTE9 BATCH_ATTRIBUTE9
, B.ATTRIBUTE10 BATCH_ATTRIBUTE10
, B.CONTEXT BATCH_CONTEXT
, B.CONTEXT2 BATCH_CONTEXT2
, B.CREATION_DATE BATCH_CREATION_DATE
, B.CREATED_BY BATCH_CREATED_BY
, B.LAST_UPDATE_DATE BATCH_LAST_UPDATE_DATE
, B.LAST_UPDATED_BY BATCH_LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN BATCH_LAST_UPDATE_LOGIN
, H.ROWID HEADER_ROW_ID
, H.JE_HEADER_ID JE_HEADER_ID
, H.NAME HEADER_NAME
, H.JE_SOURCE JE_SOURCE
, H.JE_CATEGORY JE_CATEGORY
, H.DESCRIPTION HEADER_DESCRIPTION
, H.EXTERNAL_REFERENCE EXTERNAL_REFERENCE
, H.DOC_SEQUENCE_ID DOC_SEQUENCE_ID
, H.DOC_SEQUENCE_VALUE DOC_SEQUENCE_VALUE
, H.ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID
, H.BUDGET_VERSION_ID BUDGET_VERSION_ID
, H.DEFAULT_EFFECTIVE_DATE HEADER_EFFECTIVE_DATE
, H.USSGL_TRANSACTION_CODE HEADER_USSGL_TRANSACTION_CODE
, H.CURRENCY_CODE CURRENCY_CODE
, H.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, H.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, H.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, H.ACCRUAL_REV_FLAG ACCRUAL_REV_FLAG
, H.ACCRUAL_REV_PERIOD_NAME ACCRUAL_REV_PERIOD_NAME
, H.ACCRUAL_REV_STATUS ACCRUAL_REV_STATUS
, H.CONTROL_TOTAL HEADER_CONTROL_TOTAL
, H.RUNNING_TOTAL_DR HEADER_RUNNING_TOTAL_DR
, H.RUNNING_TOTAL_CR HEADER_RUNNING_TOTAL_CR
, DECODE ( LR.RELATIONSHIP_TYPE_CODE
, 'BALANCE'
, NULL
, H.RUNNING_TOTAL_ACCOUNTED_DR ) HEADER_RUN_TOTAL_ACCOUNTED_DR
, DECODE ( LR.RELATIONSHIP_TYPE_CODE
, 'BALANCE'
, NULL
, H.RUNNING_TOTAL_ACCOUNTED_CR ) HEADER_RUN_TOTAL_ACCOUNTED_CR
, H.STATUS HEADER_STATUS
, H.DATE_CREATED HEADER_DATE_CREATED
, H.MULTI_BAL_SEG_FLAG MULTI_BAL_SEG_FLAG
, H.CONVERSION_FLAG CONVERSION_FLAG
, H.BALANCED_JE_FLAG BALANCED_JE_FLAG
, H.BALANCING_SEGMENT_VALUE BALANCING_SEGMENT_VALUE
, H.FROM_RECURRING_HEADER_ID FROM_RECURRING_HEADER_ID
, H.UNIQUE_DATE HEADER_UNIQUE_DATE
, H.EARLIEST_POSTABLE_DATE HEADER_EARLIEST_POSTABLE_DATE
, H.POSTED_DATE HEADER_POSTED_DATE
, H.ACCRUAL_REV_EFFECTIVE_DATE ACCRUAL_REV_EFFECTIVE_DATE
, H.ACCRUAL_REV_JE_HEADER_ID ACCRUAL_REV_JE_HEADER_ID
, H.ACCRUAL_REV_CHANGE_SIGN_FLAG ACCRUAL_REV_CHANGE_SIGN_FLAG
, H.PARENT_JE_HEADER_ID PARENT_JE_HEADER_ID
, H.ATTRIBUTE1 HEADER_ATTRIBUTE1
, H.ATTRIBUTE2 HEADER_ATTRIBUTE2
, H.ATTRIBUTE3 HEADER_ATTRIBUTE3
, H.ATTRIBUTE4 HEADER_ATTRIBUTE4
, H.ATTRIBUTE5 HEADER_ATTRIBUTE5
, H.ATTRIBUTE6 HEADER_ATTRIBUTE6
, H.ATTRIBUTE7 HEADER_ATTRIBUTE7
, H.ATTRIBUTE8 HEADER_ATTRIBUTE8
, H.ATTRIBUTE9 HEADER_ATTRIBUTE9
, H.ATTRIBUTE10 HEADER_ATTRIBUTE10
, H.CONTEXT HEADER_CONTEXT
, H.CONTEXT2 HEADER_CONTEXT2
, H.CREATION_DATE HEADER_CREATION_DATE
, H.CREATED_BY HEADER_CREATED_BY
, H.LAST_UPDATE_DATE HEADER_LAST_UPDATE_DATE
, H.LAST_UPDATED_BY HEADER_LAST_UPDATED_BY
, H.LAST_UPDATE_LOGIN HEADER_LAST_UPDATE_LOGIN
, LINES.ROWID ROW_ID
, LINES.LEDGER_ID LINE_LEDGER_ID
, LINES.JE_LINE_NUM LINE_JE_LINE_NUM
, LINES.CODE_COMBINATION_ID LINE_CODE_COMBINATION_ID
, LINES.PERIOD_NAME LINE_PERIOD_NAME
, LINES.EFFECTIVE_DATE LINE_EFFECTIVE_DATE
, LINES.ENTERED_DR LINE_ENTERED_DR_NUM
, LINES.ENTERED_CR LINE_ENTERED_CR_NUM
, LINES.ENTERED_DR LINE_ENTERED_DR
, LINES.ENTERED_CR LINE_ENTERED_CR
, DECODE ( LR.RELATIONSHIP_TYPE_CODE
, 'BALANCE'
, NULL
, LINES.ACCOUNTED_DR ) LINE_ACCOUNTED_DR
, DECODE ( LR.RELATIONSHIP_TYPE_CODE
, 'BALANCE'
, NULL
, LINES.ACCOUNTED_CR ) LINE_ACCOUNTED_CR
, LINES.DESCRIPTION LINE_DESCRIPTION
, LINES.REFERENCE_1 LINE_REFERENCE_1
, LINES.REFERENCE_2 LINE_REFERENCE_2
, LINES.REFERENCE_3 LINE_REFERENCE_3
, LINES.REFERENCE_4 LINE_REFERENCE_4
, LINES.REFERENCE_5 LINE_REFERENCE_5
, LINES.REFERENCE_6 LINE_REFERENCE_6
, LINES.REFERENCE_7 LINE_REFERENCE_7
, LINES.REFERENCE_8 LINE_REFERENCE_8
, LINES.REFERENCE_9 LINE_REFERENCE_9
, LINES.REFERENCE_10 LINE_REFERENCE_10
, LINES.ATTRIBUTE1 LINE_ATTRIBUTE1
, LINES.ATTRIBUTE2 LINE_ATTRIBUTE2
, LINES.ATTRIBUTE3 LINE_ATTRIBUTE3
, LINES.ATTRIBUTE4 LINE_ATTRIBUTE4
, LINES.ATTRIBUTE5 LINE_ATTRIBUTE5
, LINES.ATTRIBUTE6 LINE_ATTRIBUTE6
, LINES.ATTRIBUTE7 LINE_ATTRIBUTE7
, LINES.ATTRIBUTE8 LINE_ATTRIBUTE8
, LINES.ATTRIBUTE9 LINE_ATTRIBUTE9
, LINES.ATTRIBUTE10 LINE_ATTRIBUTE10
, LINES.ATTRIBUTE11 LINE_ATTRIBUTE11
, LINES.ATTRIBUTE12 LINE_ATTRIBUTE12
, LINES.ATTRIBUTE13 LINE_ATTRIBUTE13
, LINES.ATTRIBUTE14 LINE_ATTRIBUTE14
, LINES.ATTRIBUTE15 LINE_ATTRIBUTE15
, LINES.ATTRIBUTE16 LINE_ATTRIBUTE16
, LINES.ATTRIBUTE17 LINE_ATTRIBUTE17
, LINES.ATTRIBUTE18 LINE_ATTRIBUTE18
, LINES.ATTRIBUTE19 LINE_ATTRIBUTE19
, LINES.ATTRIBUTE20 LINE_ATTRIBUTE20
, LINES.CONTEXT LINE_CONTEXT
, LINES.CONTEXT2 LINE_CONTEXT2
, LINES.CONTEXT3 LINE_CONTEXT3
, LINES.CONTEXT4 LINE_CONTEXT4
, LINES.INVOICE_DATE LINE_INVOICE_DATE
, LINES.TAX_CODE LINE_TAX_CODE
, LINES.INVOICE_IDENTIFIER LINE_INVOICE_IDENTIFIER
, LINES.INVOICE_AMOUNT LINE_INVOICE_AMOUNT
, LINES.NO1 LINE_NO1
, LINES.STAT_AMOUNT LINE_STAT_AMOUNT
, LINES.IGNORE_RATE_FLAG LINE_IGNORE_RATE_FLAG
, LINES.USSGL_TRANSACTION_CODE LINE_USSGL_TRANSACTION_CODE
, LINES.SUBLEDGER_DOC_SEQUENCE_ID SUBLEDGER_DOC_SEQUENCE_ID
, LINES.SUBLEDGER_DOC_SEQUENCE_VALUE SUBLEDGER_DOC_SEQUENCE_VALUE
, LINES.CREATION_DATE CREATION_DATE
, LINES.CREATED_BY CREATED_BY
, LINES.LAST_UPDATE_DATE LAST_UPDATE_DATE
, LINES.LAST_UPDATED_BY LAST_UPDATED_BY
, LINES.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LR.TARGET_LEDGER_NAME LEDGER_NAME
, LR.TARGET_CURRENCY_CODE LEDGER_CURRENCY
FROM GL_PERIOD_STATUSES PS
, GL_JE_LINES LINES
, GL_JE_HEADERS H
, GL_JE_BATCHES B
, GL_LEDGER_RELATIONSHIPS LR
WHERE LR.SOURCE_LEDGER_ID = LR.TARGET_LEDGER_ID
AND LR.TARGET_CURRENCY_CODE = DECODE ( GLR03300_PKG.GET_LEDGER_CURRENCY
, 'ALL123456789012345'
, LR.TARGET_CURRENCY_CODE
, GLR03300_PKG.GET_LEDGER_CURRENCY )
AND LR.APPLICATION_ID = 101
AND B.AVERAGE_JOURNAL_FLAG = 'N'
AND B.JE_BATCH_ID = H.JE_BATCH_ID
AND B.ACTUAL_FLAG = DECODE ( GLR03300_PKG.GET_ACTUAL_FLAG
, 'E'
, DECODE ( LR.RELATIONSHIP_TYPE_CODE
, 'BALANCE'
, 'X'
, GLR03300_PKG.GET_ACTUAL_FLAG )
, GLR03300_PKG.GET_ACTUAL_FLAG )
AND H.JE_HEADER_ID = LINES.JE_HEADER_ID
AND H.CURRENCY_CODE = DECODE ( GLR03300_PKG.GET_ENTERED_CURRENCY_CODE
, 'ALL123456789012345'
, H.CURRENCY_CODE
, NULL
, H.CURRENCY_CODE
, GLR03300_PKG.GET_ENTERED_CURRENCY_CODE )
AND H.LEDGER_ID = LR.SOURCE_LEDGER_ID
AND LINES.PERIOD_NAME = PS.PERIOD_NAME
AND PS.LEDGER_ID = LINES.LEDGER_ID
AND PS.APPLICATION_ID = 101

Columns