[Home] [Help] [Dependency Information]
Object Name: | CSM_HA_AUX_MAPPINGS |
---|---|
Object Type: | TABLE |
Owner: | CSM |
Subobject Name: | |
Status: | VALID |
This table maps the business object tables to all the auxiliary tables that are dependent on it. This table is used during HA Record by the recording MFS procedure to determine additional table data that should also be stored in payload table besides the data from main table(s) used by the business object API. It is also used to store independent tables like FND_* tables at the end of a HA Record session. This table is also used while replaying the HA transactions into production database. Each Auxiliary table is associated with a table handler api, if available, that would process the auxiliary HA table data.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CSM_HA_AUX_MAPPINGS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | AUX_MAPPING_ID |
CSM_HA_AUX_MAPPINGS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
BO_TABLE_NAME
AO_TABLE_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AUX_MAPPING_ID | NUMBER | Yes | ||
BUSINESS_OBJECT_NAME | VARCHAR2 | (255) | Yes | |
BO_TABLE_NAME | VARCHAR2 | (100) | Yes | |
AUX_OBJECT_NAME | VARCHAR2 | (255) | Yes | |
AO_TABLE_NAME | VARCHAR2 | (100) | Yes | |
FOREIGN_KEY_COLUMN | VARCHAR2 | (100) | Yes | |
AUX | VARCHAR2 | (1) | ||
FETCH_SQL | VARCHAR2 | (4000) | ||
AUX_TABLE_HANDLER | VARCHAR2 | (1000) | ||
ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT AUX_MAPPING_ID
, BUSINESS_OBJECT_NAME
, BO_TABLE_NAME
, AUX_OBJECT_NAME
, AO_TABLE_NAME
, FOREIGN_KEY_COLUMN
, AUX
, FETCH_SQL
, AUX_TABLE_HANDLER
, ENABLED_FLAG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM CSM.CSM_HA_AUX_MAPPINGS;
CSM.CSM_HA_AUX_MAPPINGS does not reference any database object
CSM.CSM_HA_AUX_MAPPINGS is referenced by following:
|
|
|