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

TABLE: XLA.XLA_GL_TRANSFER_BATCHES_ALL

Object Details
Object Name: XLA_GL_TRANSFER_BATCHES_ALL
Object Type: TABLE
Owner: XLA
FND Design Data: TableXLA.XLA_GL_TRANSFER_BATCHES_ALL
Subobject Name:
Status: VALID


Transferred Batches History Table. Maintains the log of the transfers submitted.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
XLA_GL_TRANSFER_BATCHES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnGL_TRANSFER_RUN_ID
Columns
Name Datatype Length Mandatory Comments
GL_TRANSFER_RUN_ID NUMBER (15) Yes Transfer Run Id for a Batch. Unique for each set of book
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
APPLICATION_ID NUMBER (15)
Calling Application ID
USER_ID NUMBER (15)
User Id
SELECTION_TYPE NUMBER

Describes the transfer type. e.g. 1-Batch Transfer 2- Document Invoice Specific Transfer
SET_OF_BOOKS_ID NUMBER (15)
Id of the Set of Books
BATCH_NAME VARCHAR2 (30)
Transfer batch Name
SOURCE_ID NUMBER (15)
The Id of the source document.
SOURCE_TABLE VARCHAR2 (30)
Source entity that accounting event is linked to
TRANSFER_FROM_DATE DATE

Transfer start date
TRANSFER_TO_DATE DATE

Transfer end date. Used together with the transfer start date to set the transfer date range
AE_CATEGORY VARCHAR2 (30)
Describes the journal category of the document
GL_TRANSFER_MODE VARCHAR2 (1)
Describes the mode in which the transfer was submitted. D - Detail, A- Summarized by accounting date, P- Summarized by accounting period
SUBMIT_JOURNAL_IMPORT VARCHAR2 (1)
Specifies whether journal import to be submitted immediately after the transfer
SUMMARY_JOURNAL_ENTRY VARCHAR2 (1)
Specifies whether journal import should summarize the entries.
PROCESS_DAYS NUMBER

Describes number of days to be processed in one commit cycle.
GL_TRANSFER_DATE DATE

Date on which the transfer was submitted (System date)
GLLEZL_REQUEST_ID NUMBER (15)
Journal Import Request Id
INTERFACE_RUN_ID NUMBER (15)
Journal Import Processing defining column
GROUP_ID NUMBER (15)
Interface group defining column
ORG_ID NUMBER (15)
Organization identifier
LEGAL_ENTITY_ID NUMBER (15)
Legal Entity Id. Used for CST transfer
COST_TYPE_ID NUMBER (15)
Cost Type Id. Used for CST transfer.
COST_GROUP_ID NUMBER (15)
Cost Group ID Used for CST transfer
TRANSFER_STATUS VARCHAR2 (1)
Describes the transfer status. 'P' - The transfer is in progress, 'C' - The transfer completed successfully, 'N' - No rows are created.
PACKET_ID NUMBER (15)
Budgetary control packet defining column.
Query Text

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


SELECT GL_TRANSFER_RUN_ID
,      REQUEST_ID
,      APPLICATION_ID
,      USER_ID
,      SELECTION_TYPE
,      SET_OF_BOOKS_ID
,      BATCH_NAME
,      SOURCE_ID
,      SOURCE_TABLE
,      TRANSFER_FROM_DATE
,      TRANSFER_TO_DATE
,      AE_CATEGORY
,      GL_TRANSFER_MODE
,      SUBMIT_JOURNAL_IMPORT
,      SUMMARY_JOURNAL_ENTRY
,      PROCESS_DAYS
,      GL_TRANSFER_DATE
,      GLLEZL_REQUEST_ID
,      INTERFACE_RUN_ID
,      GROUP_ID
,      ORG_ID
,      LEGAL_ENTITY_ID
,      COST_TYPE_ID
,      COST_GROUP_ID
,      TRANSFER_STATUS
,      PACKET_ID
FROM XLA.XLA_GL_TRANSFER_BATCHES_ALL;

Dependencies

[top of page]

XLA.XLA_GL_TRANSFER_BATCHES_ALL does not reference any database object

XLA.XLA_GL_TRANSFER_BATCHES_ALL is referenced by following:

SchemaXLA
ViewXLA_GL_TRANSFER_BATCHES_ALL#