View: GL_JE_BATCHES_HEADERS_V

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

View Text

SELECT B.ROWID BATCH_ROW_ID
, B.JE_BATCH_ID JE_BATCH_ID
, B.CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID
, B.PERIOD_SET_NAME PERIOD_SET_NAME
, B.ACCOUNTED_PERIOD_TYPE ACCOUNTED_PERIOD_TYPE
, B.DEFAULT_PERIOD_NAME PERIOD_NAME
, B.ACTUAL_FLAG ACTUAL_FLAG
, B.STATUS BATCH_STATUS
, B.BUDGETARY_CONTROL_STATUS BUDGETARY_CONTROL_STATUS
, B.NAME BATCH_NAME
, B.DESCRIPTION BATCH_DESCRIPTION
, TRUNC(B.DATE_CREATED) BATCH_DATE_CREATED
, TRUNC(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
, B.RUNNING_TOTAL_ACCOUNTED_DR BATCH_RUN_TOTAL_ACCOUNTED_DR
, B.RUNNING_TOTAL_ACCOUNTED_CR BATCH_RUN_TOTAL_ACCOUNTED_CR
, B.AVERAGE_JOURNAL_FLAG AVERAGE_JOURNAL_FLAG
, B.STATUS_VERIFIED 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.APPROVAL_STATUS_CODE APPROVAL_STATUS_CODE
, 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 ROW_ID
, H.ROWID HEADER_ROW_ID
, H.JE_HEADER_ID JE_HEADER_ID
, H.JE_BATCH_ID HEADER_JE_BATCH_ID_QRY
, H.PERIOD_NAME HEADER_PERIOD_NAME_QRY
, H.NAME HEADER_NAME
, H.LEDGER_ID LEDGER_ID
, 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_NUM
, H.RUNNING_TOTAL_DR HEADER_RUNNING_TOTAL_DR_NUM
, H.RUNNING_TOTAL_CR HEADER_RUNNING_TOTAL_CR_NUM
, H.RUNNING_TOTAL_ACCOUNTED_DR HEADER_RUN_TOTAL_ACCOUNTED_DR
, H.RUNNING_TOTAL_ACCOUNTED_CR HEADER_RUN_TOTAL_ACCOUNTED_CR
, H.STATUS HEADER_STATUS
, H.TAX_STATUS_CODE TAX_STATUS_CODE
, TRUNC(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
, TRUNC(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.ORIGINATING_BAL_SEG_VALUE ORIGINATING_BAL_SEG_VALUE
, 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.JGZZ_RECON_CONTEXT JGZZ_RECON_CONTEXT
, H.JGZZ_RECON_REF JGZZ_RECON_REF
, H.REFERENCE_DATE REFERENCE_DATE
, H.CREATION_DATE CREATION_DATE
, H.CREATED_BY CREATED_BY
, H.LAST_UPDATE_DATE LAST_UPDATE_DATE
, H.LAST_UPDATED_BY LAST_UPDATED_BY
, H.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, B.GLOBAL_ATTRIBUTE_CATEGORY BATCH_GLOBAL_ATTRIBUTE_CAT
, B.GLOBAL_ATTRIBUTE1 BATCH_GLOBAL_ATTRIBUTE1
, B.GLOBAL_ATTRIBUTE2 BATCH_GLOBAL_ATTRIBUTE2
, B.GLOBAL_ATTRIBUTE3 BATCH_GLOBAL_ATTRIBUTE3
, B.GLOBAL_ATTRIBUTE4 BATCH_GLOBAL_ATTRIBUTE4
, B.GLOBAL_ATTRIBUTE5 BATCH_GLOBAL_ATTRIBUTE5
, B.GLOBAL_ATTRIBUTE6 BATCH_GLOBAL_ATTRIBUTE6
, B.GLOBAL_ATTRIBUTE7 BATCH_GLOBAL_ATTRIBUTE7
, B.GLOBAL_ATTRIBUTE8 BATCH_GLOBAL_ATTRIBUTE8
, B.GLOBAL_ATTRIBUTE9 BATCH_GLOBAL_ATTRIBUTE9
, B.GLOBAL_ATTRIBUTE10 BATCH_GLOBAL_ATTRIBUTE10
, B.GLOBAL_ATTRIBUTE11 BATCH_GLOBAL_ATTRIBUTE11
, B.GLOBAL_ATTRIBUTE12 BATCH_GLOBAL_ATTRIBUTE12
, B.GLOBAL_ATTRIBUTE13 BATCH_GLOBAL_ATTRIBUTE13
, B.GLOBAL_ATTRIBUTE14 BATCH_GLOBAL_ATTRIBUTE14
, B.GLOBAL_ATTRIBUTE15 BATCH_GLOBAL_ATTRIBUTE15
, B.GLOBAL_ATTRIBUTE16 BATCH_GLOBAL_ATTRIBUTE16
, B.GLOBAL_ATTRIBUTE17 BATCH_GLOBAL_ATTRIBUTE17
, B.GLOBAL_ATTRIBUTE18 BATCH_GLOBAL_ATTRIBUTE18
, B.GLOBAL_ATTRIBUTE19 BATCH_GLOBAL_ATTRIBUTE19
, B.GLOBAL_ATTRIBUTE20 BATCH_GLOBAL_ATTRIBUTE20
, H.GLOBAL_ATTRIBUTE1 HEADER_GLOBAL_ATTRIBUTE1
, H.GLOBAL_ATTRIBUTE2 HEADER_GLOBAL_ATTRIBUTE2
, H.GLOBAL_ATTRIBUTE3 HEADER_GLOBAL_ATTRIBUTE3
, H.GLOBAL_ATTRIBUTE4 HEADER_GLOBAL_ATTRIBUTE4
, H.GLOBAL_ATTRIBUTE5 HEADER_GLOBAL_ATTRIBUTE5
, H.GLOBAL_ATTRIBUTE6 HEADER_GLOBAL_ATTRIBUTE6
, H.GLOBAL_ATTRIBUTE7 HEADER_GLOBAL_ATTRIBUTE7
, H.GLOBAL_ATTRIBUTE8 HEADER_GLOBAL_ATTRIBUTE8
, H.GLOBAL_ATTRIBUTE9 HEADER_GLOBAL_ATTRIBUTE9
, H.GLOBAL_ATTRIBUTE10 HEADER_GLOBAL_ATTRIBUTE10
, H.GLOBAL_ATTRIBUTE_CATEGORY HEADER_GLOBAL_ATTRIBUTE_CAT
FROM GL_JE_BATCHES B
, GL_JE_HEADERS H
WHERE H.JE_BATCH_ID + 0 = B.JE_BATCH_ID + 0
AND (H.DISPLAY_ALC_JOURNAL_FLAG = 'Y' OR H.DISPLAY_ALC_JOURNAL_FLAG IS NULL)

Columns