DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.GL_JE_BATCHES_HEADERS_V

Object Details
Object Name: GL_JE_BATCHES_HEADERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewSQLGL.GL_JE_BATCHES_HEADERS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
BATCH_ROW_ID ROWID (10)
JE_BATCH_ID NUMBER (15) Yes
CHART_OF_ACCOUNTS_ID NUMBER (15) Yes
PERIOD_SET_NAME VARCHAR2 (15) Yes
ACCOUNTED_PERIOD_TYPE VARCHAR2 (15) Yes
PERIOD_NAME VARCHAR2 (15)
ACTUAL_FLAG VARCHAR2 (1) Yes
BATCH_STATUS VARCHAR2 (1) Yes
BUDGETARY_CONTROL_STATUS VARCHAR2 (1) Yes
BATCH_NAME VARCHAR2 (100) Yes
BATCH_DESCRIPTION VARCHAR2 (240)
BATCH_DATE_CREATED DATE

BATCH_POSTED_DATE DATE

BATCH_USSGL_TRANSACTION_CODE VARCHAR2 (30)
BATCH_CONTROL_TOTAL NUMBER

BATCH_RUNNING_TOTAL_DR NUMBER

BATCH_RUNNING_TOTAL_CR NUMBER

BATCH_RUN_TOTAL_ACCOUNTED_DR NUMBER

BATCH_RUN_TOTAL_ACCOUNTED_CR NUMBER

AVERAGE_JOURNAL_FLAG VARCHAR2 (1) Yes
STATUS_VERIFIED VARCHAR2 (1) Yes
BATCH_EFFECTIVE_DATE DATE
Yes
BATCH_STATUS_RESET_FLAG VARCHAR2 (1)
BATCH_UNIQUE_DATE VARCHAR2 (30)
BATCH_EARLIEST_POSTABLE_DATE DATE

PACKET_ID NUMBER (15)
UNRESERVATION_PACKET_ID NUMBER (15)
POSTING_RUN_ID NUMBER (15)
REQUEST_ID NUMBER (15)
APPROVAL_STATUS_CODE VARCHAR2 (1) Yes
BATCH_ATTRIBUTE1 VARCHAR2 (150)
BATCH_ATTRIBUTE2 VARCHAR2 (150)
BATCH_ATTRIBUTE3 VARCHAR2 (150)
BATCH_ATTRIBUTE4 VARCHAR2 (150)
BATCH_ATTRIBUTE5 VARCHAR2 (150)
BATCH_ATTRIBUTE6 VARCHAR2 (150)
BATCH_ATTRIBUTE7 VARCHAR2 (150)
BATCH_ATTRIBUTE8 VARCHAR2 (150)
BATCH_ATTRIBUTE9 VARCHAR2 (150)
BATCH_ATTRIBUTE10 VARCHAR2 (150)
BATCH_CONTEXT VARCHAR2 (150)
BATCH_CONTEXT2 VARCHAR2 (150)
BATCH_CREATION_DATE DATE

BATCH_CREATED_BY NUMBER (15)
BATCH_LAST_UPDATE_DATE DATE
Yes
BATCH_LAST_UPDATED_BY NUMBER (15) Yes
BATCH_LAST_UPDATE_LOGIN NUMBER (15)
ROW_ID ROWID (10)
HEADER_ROW_ID ROWID (10)
JE_HEADER_ID NUMBER (15) Yes
HEADER_JE_BATCH_ID_QRY NUMBER (15)
HEADER_PERIOD_NAME_QRY VARCHAR2 (15) Yes
HEADER_NAME VARCHAR2 (100) Yes
LEDGER_ID NUMBER (15) Yes
JE_SOURCE VARCHAR2 (25) Yes
JE_CATEGORY VARCHAR2 (25) Yes
HEADER_DESCRIPTION VARCHAR2 (240)
EXTERNAL_REFERENCE VARCHAR2 (80)
DOC_SEQUENCE_ID NUMBER

DOC_SEQUENCE_VALUE NUMBER

ENCUMBRANCE_TYPE_ID NUMBER (15)
BUDGET_VERSION_ID NUMBER (15)
HEADER_EFFECTIVE_DATE DATE
Yes
HEADER_USSGL_TRANSACTION_CODE VARCHAR2 (30)
CURRENCY_CODE VARCHAR2 (15) Yes
CURRENCY_CONVERSION_DATE DATE

CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
CURRENCY_CONVERSION_RATE NUMBER

ACCRUAL_REV_FLAG VARCHAR2 (1) Yes
ACCRUAL_REV_PERIOD_NAME VARCHAR2 (15)
ACCRUAL_REV_STATUS VARCHAR2 (1)
HEADER_CONTROL_TOTAL_NUM NUMBER

HEADER_RUNNING_TOTAL_DR_NUM NUMBER

HEADER_RUNNING_TOTAL_CR_NUM NUMBER

HEADER_RUN_TOTAL_ACCOUNTED_DR NUMBER

HEADER_RUN_TOTAL_ACCOUNTED_CR NUMBER

HEADER_STATUS VARCHAR2 (1) Yes
TAX_STATUS_CODE VARCHAR2 (1) Yes
HEADER_DATE_CREATED DATE

MULTI_BAL_SEG_FLAG VARCHAR2 (1) Yes
CONVERSION_FLAG VARCHAR2 (1)
BALANCED_JE_FLAG VARCHAR2 (1)
BALANCING_SEGMENT_VALUE VARCHAR2 (25)
FROM_RECURRING_HEADER_ID NUMBER (15)
HEADER_UNIQUE_DATE VARCHAR2 (30)
HEADER_EARLIEST_POSTABLE_DATE DATE

HEADER_POSTED_DATE DATE

ACCRUAL_REV_EFFECTIVE_DATE DATE

ACCRUAL_REV_JE_HEADER_ID NUMBER (15)
ACCRUAL_REV_CHANGE_SIGN_FLAG VARCHAR2 (1) Yes
ORIGINATING_BAL_SEG_VALUE VARCHAR2 (25)
HEADER_ATTRIBUTE1 VARCHAR2 (150)
HEADER_ATTRIBUTE2 VARCHAR2 (150)
HEADER_ATTRIBUTE3 VARCHAR2 (150)
HEADER_ATTRIBUTE4 VARCHAR2 (150)
HEADER_ATTRIBUTE5 VARCHAR2 (150)
HEADER_ATTRIBUTE6 VARCHAR2 (150)
HEADER_ATTRIBUTE7 VARCHAR2 (150)
HEADER_ATTRIBUTE8 VARCHAR2 (150)
HEADER_ATTRIBUTE9 VARCHAR2 (150)
HEADER_ATTRIBUTE10 VARCHAR2 (150)
HEADER_CONTEXT VARCHAR2 (150)
HEADER_CONTEXT2 VARCHAR2 (150)
JGZZ_RECON_CONTEXT VARCHAR2 (30)
JGZZ_RECON_REF VARCHAR2 (240)
REFERENCE_DATE DATE

CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
BATCH_GLOBAL_ATTRIBUTE_CAT VARCHAR2 (150)
Reserved for country-specific functionality
BATCH_GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
Reserved for country-specific functionality
BATCH_GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
Reserved for country-specific functionality
BATCH_GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
Reserved for country-specific functionality
BATCH_GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
Reserved for country-specific functionality
BATCH_GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
Reserved for country-specific functionality
BATCH_GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
Reserved for country-specific functionality
BATCH_GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
Reserved for country-specific functionality
BATCH_GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
Reserved for country-specific functionality
BATCH_GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
Reserved for country-specific functionality
BATCH_GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
Reserved for country-specific functionality
BATCH_GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
Reserved for country-specific functionality
BATCH_GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
Reserved for country-specific functionality
BATCH_GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
Reserved for country-specific functionality
BATCH_GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
Reserved for country-specific functionality
BATCH_GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
Reserved for country-specific functionality
BATCH_GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
Reserved for country-specific functionality
BATCH_GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
Reserved for country-specific functionality
BATCH_GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
Reserved for country-specific functionality
BATCH_GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
Reserved for country-specific functionality
BATCH_GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
Reserved for country-specific functionality
HEADER_GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
HEADER_GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
HEADER_GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
HEADER_GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
HEADER_GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
HEADER_GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
HEADER_GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
HEADER_GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
HEADER_GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
HEADER_GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
HEADER_GLOBAL_ATTRIBUTE_CAT VARCHAR2 (30)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BATCH_ROW_ID
,      JE_BATCH_ID
,      CHART_OF_ACCOUNTS_ID
,      PERIOD_SET_NAME
,      ACCOUNTED_PERIOD_TYPE
,      PERIOD_NAME
,      ACTUAL_FLAG
,      BATCH_STATUS
,      BUDGETARY_CONTROL_STATUS
,      BATCH_NAME
,      BATCH_DESCRIPTION
,      BATCH_DATE_CREATED
,      BATCH_POSTED_DATE
,      BATCH_USSGL_TRANSACTION_CODE
,      BATCH_CONTROL_TOTAL
,      BATCH_RUNNING_TOTAL_DR
,      BATCH_RUNNING_TOTAL_CR
,      BATCH_RUN_TOTAL_ACCOUNTED_DR
,      BATCH_RUN_TOTAL_ACCOUNTED_CR
,      AVERAGE_JOURNAL_FLAG
,      STATUS_VERIFIED
,      BATCH_EFFECTIVE_DATE
,      BATCH_STATUS_RESET_FLAG
,      BATCH_UNIQUE_DATE
,      BATCH_EARLIEST_POSTABLE_DATE
,      PACKET_ID
,      UNRESERVATION_PACKET_ID
,      POSTING_RUN_ID
,      REQUEST_ID
,      APPROVAL_STATUS_CODE
,      BATCH_ATTRIBUTE1
,      BATCH_ATTRIBUTE2
,      BATCH_ATTRIBUTE3
,      BATCH_ATTRIBUTE4
,      BATCH_ATTRIBUTE5
,      BATCH_ATTRIBUTE6
,      BATCH_ATTRIBUTE7
,      BATCH_ATTRIBUTE8
,      BATCH_ATTRIBUTE9
,      BATCH_ATTRIBUTE10
,      BATCH_CONTEXT
,      BATCH_CONTEXT2
,      BATCH_CREATION_DATE
,      BATCH_CREATED_BY
,      BATCH_LAST_UPDATE_DATE
,      BATCH_LAST_UPDATED_BY
,      BATCH_LAST_UPDATE_LOGIN
,      ROW_ID
,      HEADER_ROW_ID
,      JE_HEADER_ID
,      HEADER_JE_BATCH_ID_QRY
,      HEADER_PERIOD_NAME_QRY
,      HEADER_NAME
,      LEDGER_ID
,      JE_SOURCE
,      JE_CATEGORY
,      HEADER_DESCRIPTION
,      EXTERNAL_REFERENCE
,      DOC_SEQUENCE_ID
,      DOC_SEQUENCE_VALUE
,      ENCUMBRANCE_TYPE_ID
,      BUDGET_VERSION_ID
,      HEADER_EFFECTIVE_DATE
,      HEADER_USSGL_TRANSACTION_CODE
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      ACCRUAL_REV_FLAG
,      ACCRUAL_REV_PERIOD_NAME
,      ACCRUAL_REV_STATUS
,      HEADER_CONTROL_TOTAL_NUM
,      HEADER_RUNNING_TOTAL_DR_NUM
,      HEADER_RUNNING_TOTAL_CR_NUM
,      HEADER_RUN_TOTAL_ACCOUNTED_DR
,      HEADER_RUN_TOTAL_ACCOUNTED_CR
,      HEADER_STATUS
,      TAX_STATUS_CODE
,      HEADER_DATE_CREATED
,      MULTI_BAL_SEG_FLAG
,      CONVERSION_FLAG
,      BALANCED_JE_FLAG
,      BALANCING_SEGMENT_VALUE
,      FROM_RECURRING_HEADER_ID
,      HEADER_UNIQUE_DATE
,      HEADER_EARLIEST_POSTABLE_DATE
,      HEADER_POSTED_DATE
,      ACCRUAL_REV_EFFECTIVE_DATE
,      ACCRUAL_REV_JE_HEADER_ID
,      ACCRUAL_REV_CHANGE_SIGN_FLAG
,      ORIGINATING_BAL_SEG_VALUE
,      HEADER_ATTRIBUTE1
,      HEADER_ATTRIBUTE2
,      HEADER_ATTRIBUTE3
,      HEADER_ATTRIBUTE4
,      HEADER_ATTRIBUTE5
,      HEADER_ATTRIBUTE6
,      HEADER_ATTRIBUTE7
,      HEADER_ATTRIBUTE8
,      HEADER_ATTRIBUTE9
,      HEADER_ATTRIBUTE10
,      HEADER_CONTEXT
,      HEADER_CONTEXT2
,      JGZZ_RECON_CONTEXT
,      JGZZ_RECON_REF
,      REFERENCE_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      BATCH_GLOBAL_ATTRIBUTE_CAT
,      BATCH_GLOBAL_ATTRIBUTE1
,      BATCH_GLOBAL_ATTRIBUTE2
,      BATCH_GLOBAL_ATTRIBUTE3
,      BATCH_GLOBAL_ATTRIBUTE4
,      BATCH_GLOBAL_ATTRIBUTE5
,      BATCH_GLOBAL_ATTRIBUTE6
,      BATCH_GLOBAL_ATTRIBUTE7
,      BATCH_GLOBAL_ATTRIBUTE8
,      BATCH_GLOBAL_ATTRIBUTE9
,      BATCH_GLOBAL_ATTRIBUTE10
,      BATCH_GLOBAL_ATTRIBUTE11
,      BATCH_GLOBAL_ATTRIBUTE12
,      BATCH_GLOBAL_ATTRIBUTE13
,      BATCH_GLOBAL_ATTRIBUTE14
,      BATCH_GLOBAL_ATTRIBUTE15
,      BATCH_GLOBAL_ATTRIBUTE16
,      BATCH_GLOBAL_ATTRIBUTE17
,      BATCH_GLOBAL_ATTRIBUTE18
,      BATCH_GLOBAL_ATTRIBUTE19
,      BATCH_GLOBAL_ATTRIBUTE20
,      HEADER_GLOBAL_ATTRIBUTE1
,      HEADER_GLOBAL_ATTRIBUTE2
,      HEADER_GLOBAL_ATTRIBUTE3
,      HEADER_GLOBAL_ATTRIBUTE4
,      HEADER_GLOBAL_ATTRIBUTE5
,      HEADER_GLOBAL_ATTRIBUTE6
,      HEADER_GLOBAL_ATTRIBUTE7
,      HEADER_GLOBAL_ATTRIBUTE8
,      HEADER_GLOBAL_ATTRIBUTE9
,      HEADER_GLOBAL_ATTRIBUTE10
,      HEADER_GLOBAL_ATTRIBUTE_CAT
FROM APPS.GL_JE_BATCHES_HEADERS_V;

Dependencies

[top of page]

APPS.GL_JE_BATCHES_HEADERS_V references the following:

SchemaAPPS
SynonymGL_JE_BATCHES
SynonymGL_JE_HEADERS

APPS.GL_JE_BATCHES_HEADERS_V is not referenced by any database object