VIEW: APPS.GL_JE_HEADERS_V

Source

View Text - Preformatted

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, h.global_attribute1 GLOBAL_ATTRIBUTE1, h.global_attribute2 GLOBAL_ATTRIBUTE2, h.global_attribute3 GLOBAL_ATTRIBUTE3, h.global_attribute4 GLOBAL_ATTRIBUTE4, h.global_attribute5 GLOBAL_ATTRIBUTE5, h.global_attribute6 GLOBAL_ATTRIBUTE6, h.global_attribute7 GLOBAL_ATTRIBUTE7, h.global_attribute8 GLOBAL_ATTRIBUTE8, h.global_attribute9 GLOBAL_ATTRIBUTE9, h.global_attribute10 GLOBAL_ATTRIBUTE10, h.global_attribute_category GLOBAL_ATTRIBUTE_CATEGORY 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)

View Text - HTML Formatted

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
, H.GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, H.GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, H.GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, H.GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, H.GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, H.GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, H.GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, H.GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, H.GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, H.GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, H.GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
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)