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_PLAN_CHAR_ACTIONS

Object Details

Object Name:	QA_PLAN_CHAR_ACTIONS
Object Type:	TABLE
Owner:	QA
FND Design Data:	QA.QA_PLAN_CHAR_ACTIONS
Subobject Name:
Status:	VALID

QA_PLAN_CHAR_ACTIONS contains defined actions for collection plan
elements. Each row of the table represents one action assigned to a collection element in a collection plan.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QA_PC_ACTIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PLAN_CHAR_ACTION_ID
QA_PC_ACTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PLAN_CHAR_ACTION_TRIGGER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PLAN_CHAR_ACTION_ID	NUMBER		Yes	Action Identifier for a given collection element and plan
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
PLAN_CHAR_ACTION_TRIGGER_ID	NUMBER		Yes	Action trigger Identifier for the given action
ACTION_ID	NUMBER		Yes	Action Identifier
CAR_NAME_PREFIX	VARCHAR2	(20)		Intended for future use with corrective ation module
CAR_TYPE_ID	NUMBER			Intended for future use with corrective ation module
CAR_OWNER	NUMBER			Intended for future use with corrective ation module
MESSAGE	VARCHAR2	(2000)		This field stores the action message or action details for the action. For example, if action is to display a message to the operator, this field will store the actual message to be displayed.
STATUS_CODE	VARCHAR2	(30)		Stores additional action details. For example, if the action is to assign an ASL status, this field will store the actual status code that will be assigned.
ALR_ACTION_SET_ID	NUMBER			Oracle Alert action set Identifier
ALR_ACTION_ID	NUMBER			Oracle Alert action Identifier
ASSIGNED_CHAR_ID	NUMBER			Identifier to destination collection element for "Assign a value to a collection element" action
ASSIGN_TYPE	VARCHAR2	(1)		Indicates whether a SQL statement or a formula has been entered by the user to calculate the value for "Assign a value to a collection element" action
STATUS_ID	NUMBER			Status Identifier

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PLAN_CHAR_ACTION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PLAN_CHAR_ACTION_TRIGGER_ID
,      ACTION_ID
,      CAR_NAME_PREFIX
,      CAR_TYPE_ID
,      CAR_OWNER
,      MESSAGE
,      STATUS_CODE
,      ALR_ACTION_SET_ID
,      ALR_ACTION_ID
,      ASSIGNED_CHAR_ID
,      ASSIGN_TYPE
,      STATUS_ID
FROM QA.QA_PLAN_CHAR_ACTIONS;

Dependencies

[top of page]

QA.QA_PLAN_CHAR_ACTIONS does not reference any database object

QA.QA_PLAN_CHAR_ACTIONS is referenced by following:

APPS: QA_PLAN_CHAR_ACTIONS