[Home] [Help] [Dependency Information]
Object Name: | CST_XLA_SEQ_GT |
---|---|
Object Type: | TABLE |
Owner: | BOM |
FND Design Data: | BOM.CST_XLA_SEQ_GT |
Subobject Name: | |
Status: | VALID |
Temporary table is usd in Costing SLA Upgrade to generate XLA entity_id, event_id, and header_id from XLA sequences for every XLA events.
BOM.CST_XLA_SEQ_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SOURCE_ID_INT_1 | NUMBER | Source transaction identifier; it is used to populate XLA_TRANSACTION_ENTITIES.SOURCE_ID_INT_1. | ||
SOURCE_ID_INT_2 | NUMBER | Source transaction identifier; it is used to populate XLA_TRANSACTION_ENTITIES.SOURCE_ID_INT_2. | ||
SOURCE_ID_INT_3 | NUMBER | Source transaction identifier; it is used to populate XLA_TRANSACTION_ENTITIES.SOURCE_ID_INT_3. | ||
SOURCE_ID_INT_4 | NUMBER | Source transaction identifier; it is used to populate XLA_TRANSACTION_ENTITIES.SOURCE_ID_INT_4. | ||
SOURCE_ID_INT_5 | NUMBER | Source transaction identifier; for future use. | ||
ENTITY_ID | NUMBER | XLA transaction entity identifier; it is used to populate XLA_TRANSACTION_ENTITIES.ENTITY_ID. It is populated by XLA_TRANSACTION_ENTITIES_S.nextval | ||
EVENT_ID | NUMBER | XLA event identifier; it is used to populate XLA_EVENTS.EVENT_ID. It is populated by XLA_EVENTS_S.nextval | ||
HEADER_ID | NUMBER | XLA journal entry header identifier; it is used to populate XLA_AE_HEADERS.HEADER_ID. It is populated by XLA_AE_HEADERS_S.nextval | ||
LEGAL_ENTITY | NUMBER | Legal Entity identifier | ||
ORG_ID | NUMBER | Operation Unit identifier |
Cut, paste (and edit) the following text to query this object:
SELECT SOURCE_ID_INT_1
, SOURCE_ID_INT_2
, SOURCE_ID_INT_3
, SOURCE_ID_INT_4
, SOURCE_ID_INT_5
, ENTITY_ID
, EVENT_ID
, HEADER_ID
, LEGAL_ENTITY
, ORG_ID
FROM BOM.CST_XLA_SEQ_GT;
BOM.CST_XLA_SEQ_GT does not reference any database object
BOM.CST_XLA_SEQ_GT is referenced by following:
|
|
|