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

TABLE: GL.GL_AUTO_ALLOC_BATCHES

Object Details
Object Name: GL_AUTO_ALLOC_BATCHES
Object Type: TABLE
Owner: GL
FND Design Data: TableSQLGL.GL_AUTO_ALLOC_BATCHES
Subobject Name:
Status: VALID


GL_AUTO_ALLOC_BATCHES stores one row for each batch included in the allocation set. Each row includes step_number, batch_id, batch_name, batch_type, owner, and allocation method. For a step-down allocation set, the STEP NUMBER specifies the sequence in which the batch should be generated and posted. BATCH_TYPE_CODE is either 'A', 'B', 'E', 'R' or 'P' for MassAllocation, MassBudgets, Encumbrances, Recurring, or Projects batches respectively.
ALLOCATION_METHOD_CODE is 'I' for incremental allocation or 'F' for full allocation method. Owner represents the role name, defined in WF_ROLES table, who will receive the notification when any error occurs in step-down allocation run.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GL_AUTO_ALLOC_BATCHES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnALLOCATION_SET_ID
ColumnBATCH_ID
ColumnBATCH_TYPE_CODE
GL_AUTO_ALLOC_BATCHES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBATCH_ID
Columns
Name Datatype Length Mandatory Comments
ALLOCATION_SET_ID NUMBER (15) Yes Allocation set defining column
BATCH_ID NUMBER (15) Yes Defining column for Massallocation batch, Recurring Journal Batch, or Project batch.
BATCH_TYPE_CODE VARCHAR2 (1) Yes Batch type (MassAllocations, MassBudgets, MassEncumbrances, Recurring Journals, or Project)
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
STEP_NUMBER NUMBER (15)
Sequence in which batch is to be generated by step-down set.
OWNER VARCHAR2 (100)
The owner/role specified for a Allocation batch who will receive a notification when any error occurs in Step-down allocations set
ALLOCATION_METHOD_CODE VARCHAR2 (1)
Allocation method used for batch generation.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
CONTEXT VARCHAR2 (150)
Descriptive flexfield context
Query Text

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


SELECT ALLOCATION_SET_ID
,      BATCH_ID
,      BATCH_TYPE_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      STEP_NUMBER
,      OWNER
,      ALLOCATION_METHOD_CODE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CONTEXT
FROM GL.GL_AUTO_ALLOC_BATCHES;

Dependencies

[top of page]

GL.GL_AUTO_ALLOC_BATCHES does not reference any database object

GL.GL_AUTO_ALLOC_BATCHES is referenced by following:

SchemaAPPS
SynonymGL_AUTO_ALLOC_BATCHES