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

TABLE: QA.QA_PLAN_CHAR_ACTION_OUTPUTS

Object Details
Object Name: QA_PLAN_CHAR_ACTION_OUTPUTS
Object Type: TABLE
Owner: QA
FND Design Data: TableQA.QA_PLAN_CHAR_ACTION_OUTPUTS
Subobject Name:
Status: VALID


QA_PLAN_CHAR_ACTION_OUTPUTS stores the mapping between collection elements and tokens used in defining actions for a specific collection plan. Oracle Quality allows the user to define actions based on the tokens for some of the actions. These tokens are substituted with actual collection element values while executing the actions. Each row of this table stores information about a collection element, along with its associated action and the token name used to define the action in a specific plan.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
QA_PC_ACTION_OUTPUTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPLAN_CHAR_ACTION_ID
ColumnTOKEN_NAME
Columns
Name Datatype Length Mandatory Comments
PLAN_CHAR_ACTION_ID NUMBER
Yes Action Identifier defined for a collection element for a given plan
TOKEN_NAME VARCHAR2 (30) Yes Name of the token variable used for defining the action
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_ID NUMBER
Yes Collection element Identifier
Query Text

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


SELECT PLAN_CHAR_ACTION_ID
,      TOKEN_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CHAR_ID
FROM QA.QA_PLAN_CHAR_ACTION_OUTPUTS;

Dependencies

[top of page]

QA.QA_PLAN_CHAR_ACTION_OUTPUTS does not reference any database object

QA.QA_PLAN_CHAR_ACTION_OUTPUTS is referenced by following:

SchemaAPPS
SynonymQA_PLAN_CHAR_ACTION_OUTPUTS