View: GL_JE_HEADERS_V

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

View Text

SELECT H.ROWID ROW_ID
, H.JE_HEADER_ID JE_HEADER_ID
, H.NAME NAME
, B.CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID
, B.PERIOD_SET_NAME PERIOD_SET_NAME
, B.ACCOUNTED_PERIOD_TYPE ACCOUNTED_PERIOD_TYPE
, H.JE_SOURCE JE_SOURCE
, H.JE_CATEGORY JE_CATEGORY
, H.DESCRIPTION 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 DEFAULT_EFFECTIVE_DATE
, H.USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, H.CURRENCY_CODE CURRENCY_CODE
, H.CURRENCY_CODE CURRENCY_CODE2
, 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.ORIGINATING_BAL_SEG_VALUE ORIGINATING_BAL_SEG_VALUE
, H.CONTROL_TOTAL CONTROL_TOTAL
, H.RUNNING_TOTAL_DR RUNNING_TOTAL_DR
, H.RUNNING_TOTAL_CR RUNNING_TOTAL_CR
, H.RUNNING_TOTAL_ACCOUNTED_DR RUNNING_TOTAL_ACCOUNTED_DR
, H.RUNNING_TOTAL_ACCOUNTED_CR RUNNING_TOTAL_ACCOUNTED_CR
, H.LEDGER_ID LEDGER_ID
, H.PERIOD_NAME PERIOD_NAME
, H.STATUS STATUS
, TRUNC(H.DATE_CREATED) DATE_CREATED
, H.MULTI_BAL_SEG_FLAG MULTI_BAL_SEG_FLAG
, H.ACTUAL_FLAG ACTUAL_FLAG
, H.CONVERSION_FLAG CONVERSION_FLAG
, H.BALANCED_JE_FLAG BALANCED_JE_FLAG
, H.BALANCING_SEGMENT_VALUE BALANCING_SEGMENT_VALUE
, H.JE_BATCH_ID JE_BATCH_ID
, H.FROM_RECURRING_HEADER_ID FROM_RECURRING_HEADER_ID
, H.UNIQUE_DATE UNIQUE_DATE
, H.EARLIEST_POSTABLE_DATE EARLIEST_POSTABLE_DATE
, TRUNC(H.POSTED_DATE) 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.TAX_STATUS_CODE TAX_STATUS_CODE
, H.ATTRIBUTE1 ATTRIBUTE1
, H.ATTRIBUTE2 ATTRIBUTE2
, H.ATTRIBUTE3 ATTRIBUTE3
, H.ATTRIBUTE4 ATTRIBUTE4
, H.ATTRIBUTE5 ATTRIBUTE5
, H.ATTRIBUTE6 ATTRIBUTE6
, H.ATTRIBUTE7 ATTRIBUTE7
, H.ATTRIBUTE8 ATTRIBUTE8
, H.ATTRIBUTE9 ATTRIBUTE9
, H.ATTRIBUTE10 ATTRIBUTE10
, H.CONTEXT CONTEXT
, H.CONTEXT2 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.ROWID BATCH_ROWID
, B.JE_BATCH_ID BATCH_JE_BATCH_ID_QRY
, B.DEFAULT_PERIOD_NAME BATCH_PERIOD_NAME_QRY
, B.NAME BATCH_NAME
, B.STATUS BATCH_STATUS
, B.BUDGETARY_CONTROL_STATUS BUDGETARY_CONTROL_STATUS
, B.STATUS_VERIFIED STATUS_VERIFIED
, TRUNC(B.DATE_CREATED) BATCH_DATE_CREATED
, TRUNC(B.POSTED_DATE) BATCH_POSTED_DATE
, B.DEFAULT_EFFECTIVE_DATE BATCH_DEFAULT_EFFECTIVE_DATE
, B.PACKET_ID PACKET_ID
, B.UNRESERVATION_PACKET_ID UNRESERVATION_PACKET_ID
, B.REQUEST_ID REQUEST_ID
, B.POSTING_RUN_ID POSTING_RUN_ID
, B.CONTROL_TOTAL BATCH_CONTROL_TOTAL
, B.RUNNING_TOTAL_DR BATCH_RUNNING_TOTAL_DR
, B.RUNNING_TOTAL_CR BATCH_RUNNING_TOTAL_CR
, B.AVERAGE_JOURNAL_FLAG AVERAGE_JOURNAL_FLAG
, B.ORG_ID ORG_ID
, B.APPROVAL_STATUS_CODE APPROVAL_STATUS_CODE
, H.PARENT_JE_HEADER_ID PARENT_JE_HEADER_ID
, H.REVERSED_JE_HEADER_ID REVERSED_JE_HEADER_ID
, H.POSTING_ACCT_SEQ_VALUE POSTING_ACCT_SEQ_VALUE
, H.POSTING_ACCT_SEQ_VERSION_ID POSTING_ACCT_SEQ_VERSION_ID
, H.CLOSE_ACCT_SEQ_VALUE CLOSE_ACCT_SEQ_VALUE
, H.CLOSE_ACCT_SEQ_VERSION_ID CLOSE_ACCT_SEQ_VERSION_ID
FROM GL_JE_HEADERS H
, GL_JE_BATCHES B
WHERE B.JE_BATCH_ID + 0 = H.JE_BATCH_ID + 0
AND (H.DISPLAY_ALC_JOURNAL_FLAG = 'Y' OR H.DISPLAY_ALC_JOURNAL_FLAG IS NULL)

Columns