[Home] [Help] [Dependency Information]
Object Name: | BOM_DELETE_ERRORS |
---|---|
Object Type: | TABLE |
Owner: | BOM |
FND Design Data: | BOM.BOM_DELETE_ERRORS |
Subobject Name: | |
Status: | VALID |
BOM_DELETE_ERRORS stores information about constraints that are
violated for every entity that you try to delete. Oracle Bills of
Material retrieves the translated error message using the message name
associated with every failed constraint.
.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BOM_DELETE_ERRORS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
DELETE_ENTITY_SEQUENCE_ID
COMPONENT_SEQUENCE_ID OPERATION_SEQUENCE_ID ERROR_SEQUENCE_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DELETE_ENTITY_SEQUENCE_ID | NUMBER | Yes | Delete entity unique identifier | |
COMPONENT_SEQUENCE_ID | NUMBER | Component unique identifier | ||
OPERATION_SEQUENCE_ID | NUMBER | Routing operation unique identifier | ||
ERROR_SEQUENCE_NUMBER | NUMBER | Yes | Error sequence number | |
SQL_STATEMENT_NAME | VARCHAR2 | (10) | Yes | Name of failed sql statement |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
REQUEST_ID | NUMBER | Concurrent Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Who column | ||
PROGRAM_ID | NUMBER | Concurrent Who column | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Who column |
Cut, paste (and edit) the following text to query this object:
SELECT DELETE_ENTITY_SEQUENCE_ID
, COMPONENT_SEQUENCE_ID
, OPERATION_SEQUENCE_ID
, ERROR_SEQUENCE_NUMBER
, SQL_STATEMENT_NAME
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM BOM.BOM_DELETE_ERRORS;
BOM.BOM_DELETE_ERRORS does not reference any database object
BOM.BOM_DELETE_ERRORS is referenced by following:
|
|
|