VIEW: GL.GL_JE_BATCHES#

Source

View Text - Preformatted

select JE_BATCH_ID JE_BATCH_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, SET_OF_BOOKS_ID_11I SET_OF_BOOKS_ID_11I, NAME NAME, STATUS STATUS, STATUS_VERIFIED STATUS_VERIFIED, ACTUAL_FLAG ACTUAL_FLAG, DEFAULT_EFFECTIVE_DATE DEFAULT_EFFECTIVE_DATE, AVERAGE_JOURNAL_FLAG AVERAGE_JOURNAL_FLAG, BUDGETARY_CONTROL_STATUS BUDGETARY_CONTROL_STATUS, APPROVAL_STATUS_CODE APPROVAL_STATUS_CODE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, STATUS_RESET_FLAG STATUS_RESET_FLAG, DEFAULT_PERIOD_NAME DEFAULT_PERIOD_NAME, UNIQUE_DATE UNIQUE_DATE, EARLIEST_POSTABLE_DATE EARLIEST_POSTABLE_DATE, POSTED_DATE POSTED_DATE, DATE_CREATED DATE_CREATED, DESCRIPTION DESCRIPTION, CONTROL_TOTAL CONTROL_TOTAL, RUNNING_TOTAL_DR RUNNING_TOTAL_DR, RUNNING_TOTAL_CR RUNNING_TOTAL_CR, RUNNING_TOTAL_ACCOUNTED_DR RUNNING_TOTAL_ACCOUNTED_DR, RUNNING_TOTAL_ACCOUNTED_CR RUNNING_TOTAL_ACCOUNTED_CR, PARENT_JE_BATCH_ID PARENT_JE_BATCH_ID, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, CONTEXT CONTEXT, UNRESERVATION_PACKET_ID UNRESERVATION_PACKET_ID, PACKET_ID PACKET_ID, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, CONTEXT2 CONTEXT2, POSTING_RUN_ID POSTING_RUN_ID, REQUEST_ID REQUEST_ID, ORG_ID ORG_ID, POSTED_BY POSTED_BY, CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID, PERIOD_SET_NAME PERIOD_SET_NAME, ACCOUNTED_PERIOD_TYPE ACCOUNTED_PERIOD_TYPE, GROUP_ID GROUP_ID, APPROVER_EMPLOYEE_ID APPROVER_EMPLOYEE_ID, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20 from "GL"."GL_JE_BATCHES"

View Text - HTML Formatted

SELECT JE_BATCH_ID JE_BATCH_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, SET_OF_BOOKS_ID_11I SET_OF_BOOKS_ID_11I
, NAME NAME
, STATUS STATUS
, STATUS_VERIFIED STATUS_VERIFIED
, ACTUAL_FLAG ACTUAL_FLAG
, DEFAULT_EFFECTIVE_DATE DEFAULT_EFFECTIVE_DATE
, AVERAGE_JOURNAL_FLAG AVERAGE_JOURNAL_FLAG
, BUDGETARY_CONTROL_STATUS BUDGETARY_CONTROL_STATUS
, APPROVAL_STATUS_CODE APPROVAL_STATUS_CODE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, STATUS_RESET_FLAG STATUS_RESET_FLAG
, DEFAULT_PERIOD_NAME DEFAULT_PERIOD_NAME
, UNIQUE_DATE UNIQUE_DATE
, EARLIEST_POSTABLE_DATE EARLIEST_POSTABLE_DATE
, POSTED_DATE POSTED_DATE
, DATE_CREATED DATE_CREATED
, DESCRIPTION DESCRIPTION
, CONTROL_TOTAL CONTROL_TOTAL
, RUNNING_TOTAL_DR RUNNING_TOTAL_DR
, RUNNING_TOTAL_CR RUNNING_TOTAL_CR
, RUNNING_TOTAL_ACCOUNTED_DR RUNNING_TOTAL_ACCOUNTED_DR
, RUNNING_TOTAL_ACCOUNTED_CR RUNNING_TOTAL_ACCOUNTED_CR
, PARENT_JE_BATCH_ID PARENT_JE_BATCH_ID
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, CONTEXT CONTEXT
, UNRESERVATION_PACKET_ID UNRESERVATION_PACKET_ID
, PACKET_ID PACKET_ID
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, CONTEXT2 CONTEXT2
, POSTING_RUN_ID POSTING_RUN_ID
, REQUEST_ID REQUEST_ID
, ORG_ID ORG_ID
, POSTED_BY POSTED_BY
, CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID
, PERIOD_SET_NAME PERIOD_SET_NAME
, ACCOUNTED_PERIOD_TYPE ACCOUNTED_PERIOD_TYPE
, GROUP_ID GROUP_ID
, APPROVER_EMPLOYEE_ID APPROVER_EMPLOYEE_ID
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
FROM "GL"."GL_JE_BATCHES"