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_ACTION_TRIGGERS

Object Details

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

QA_CHAR_ACTION_TRIGGERS contains one row for each defined action trigger associated with a collection element. Action triggers are the rules that specify the conditions under which the action is activated during results entry. When the specified condition is met, the designated action is activated. You can define more than one trigger for a collection element. You assign each trigger a sequence number, which indicates the order in which the trigger is activated.
Each row in the table contains a collection element Identifier, a trigger sequence, and the operator used to define the trigger for the collection element. Operators are assigned numeric equivalents, which are displayed in the table. For example, the Less Than (<) operator is represented by the number six.
Based on the operator used, a row may contain a single value, or two values used to define a range of values from low (LOW_VALUE_OTHER) to high (HIGH_VALUE_OTHER). For example, if you use the operator Equals (=), which is represented by the number one, you enter a single value in the LOW_VALUE_OTHER field. When the user enters a collection element for this value, the action rule evaluates to TRUE. If you use the operator Between, which is represented by the number nine and indicates a range of values, you must specify a value for both LOW_VALUE_OTHER and HIGH_VALUE_OTHER. When the user enters a collection element value that falls within that range, the action rule is evaluated to TRUE. If the LOW_VALUE_LOOKUP or HIGH_VALUE_LOOKUP fields are populated, the collection element's specification limits determine whether or not the action is activated. If these fields are NULL, the actual values from LOW_VALUE_OTHER and HIGH_VALUE_OTHER determine whether or not the action is activated.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QA_PC_ACTION_TRIGGERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PLAN_CHAR_ACTION_TRIGGER_ID
QA_PC_ACTION_TRIGGERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PLAN_ID CHAR_ID TRIGGER_SEQUENCE

Columns

Name	Datatype	Length	Mandatory	Comments
PLAN_CHAR_ACTION_TRIGGER_ID	NUMBER		Yes	Action trigger Identifier for the given collection element and collection 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
TRIGGER_SEQUENCE	NUMBER		Yes	Sequence number of trigger. This sequence is used to evaluate trigger priority
PLAN_ID	NUMBER		Yes	Collection plan Identifier
CHAR_ID	NUMBER		Yes	Collection element Identifier
OPERATOR	NUMBER		Yes	Operator used in defining this trigger
LOW_VALUE_LOOKUP	NUMBER			Code for specification limit, user-defined limit, or collection element target value. If the value entered is equal to or greater than this value, trigger will be evaluated to TRUE based on the operator used
HIGH_VALUE_LOOKUP	NUMBER			Code for specification limit, user-defined limit, or collection element target value. If the value entered is equal to or less than this value, trigger will be evaluated to TRUE based on the operator used
LOW_VALUE_OTHER	VARCHAR2	(150)		Collection element low value as defined in action rule. This column is used as lower limit to the collection element range or collection element value for which action will be fired, based on the operator used in defining the trigger
LOW_VALUE_OTHER_ID	NUMBER			Stores Flexfield ID for collection elements that are Flexfields
HIGH_VALUE_OTHER	VARCHAR2	(150)		Upper limit to the collection element value range
HIGH_VALUE_OTHER_ID	NUMBER			Flexfield ID for collection elements that are Flexfields

Query Text

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


SELECT PLAN_CHAR_ACTION_TRIGGER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      TRIGGER_SEQUENCE
,      PLAN_ID
,      CHAR_ID
,      OPERATOR
,      LOW_VALUE_LOOKUP
,      HIGH_VALUE_LOOKUP
,      LOW_VALUE_OTHER
,      LOW_VALUE_OTHER_ID
,      HIGH_VALUE_OTHER
,      HIGH_VALUE_OTHER_ID
FROM QA.QA_PLAN_CHAR_ACTION_TRIGGERS;

Dependencies

[top of page]

QA.QA_PLAN_CHAR_ACTION_TRIGGERS does not reference any database object

QA.QA_PLAN_CHAR_ACTION_TRIGGERS is referenced by following:

APPS: QA_PLAN_CHAR_ACTION_TRIGGERS