[Home] [Help] [Dependency Information]
Object Name: | QA_CHAR_ACTIONS |
---|---|
Object Type: | TABLE |
Owner: | QA |
FND Design Data: | QA.QA_CHAR_ACTIONS |
Subobject Name: | |
Status: | VALID |
QA_CHAR_ACTIONS contains actions defined for collection elements. Each row of the table defines one action and its detail.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
QA_CHAR_ACTIONS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | CHAR_ACTION_ID |
QA_CHAR_ACTIONS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CHAR_ACTION_TRIGGER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CHAR_ACTION_ID | NUMBER | Yes | Collection element action Identifier | |
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 | ||
CHAR_ACTION_TRIGGER_ID | NUMBER | Yes | Foreign key to table QA_CHAR_ACTION_TRIGGERS. This column identifies the action rules associated with this action. | |
ACTION_ID | NUMBER | Yes | Action Identifier | |
CAR_NAME_PREFIX | VARCHAR2 | (20) | This column is intended to be used in future for corrective action functionality | |
CAR_TYPE_ID | NUMBER | This column is intended to be used in future for corrective action functionality | ||
CAR_OWNER | NUMBER | This column is intended to be used in future for corrective action functionality | ||
MESSAGE | VARCHAR2 | (240) | This field stores the message or details for the action. For example, if the action is to display a message to the operator, this field stores the actual message to be displayed. | |
STATUS_CODE | VARCHAR2 | (30) | Stores detailed information about the action. For example, if the action is to assign an ASL status, this field contains the actual status code to be assigned. | |
ALR_ACTION_SET_ID | NUMBER | Alert action set Identifier used for Oracle Quality actions that use Oracle Alert | ||
ALR_ACTION_ID | NUMBER | Alert action Identifier used for Quality actions that use Oracle Alert | ||
STATUS_ID | NUMBER | Status Identifier |
Cut, paste (and edit) the following text to query this object:
SELECT CHAR_ACTION_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, CHAR_ACTION_TRIGGER_ID
, ACTION_ID
, CAR_NAME_PREFIX
, CAR_TYPE_ID
, CAR_OWNER
, MESSAGE
, STATUS_CODE
, ALR_ACTION_SET_ID
, ALR_ACTION_ID
, STATUS_ID
FROM QA.QA_CHAR_ACTIONS;
QA.QA_CHAR_ACTIONS does not reference any database object
QA.QA_CHAR_ACTIONS is referenced by following:
|
|
|