[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
QA.QA_PLAN_CHAR_ACTIONS does not reference any database object
QA.QA_PLAN_CHAR_ACTIONS is referenced by following:
|
|
|