eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: QA.QA_CHAR_ACTIONS

Object Details

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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

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

Columns

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

Query Text

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;

Dependencies

[top of page]

QA.QA_CHAR_ACTIONS does not reference any database object

QA.QA_CHAR_ACTIONS is referenced by following:

QA: QA_CHAR_ACTIONS#