VIEW: APPS.GL_JE_BATCHES_HEADERS_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)