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

TABLE: QA.QA_ACTIONS

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


QA_ACTIONS stores the master list of actions available in Oracle Quality. Each row of the table defines one action and provides its description. Actions may be enabled or disabled as indicated by the flag ENABLED_FLAG and may be visible to the user or run in the background. All enabled actions in this table are available to users during collection element and collection plan definitions and are triggered during results entry. All information in the table is pre-seeded and should not be changed.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
QA_ACTIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnACTION_ID
Columns
Name Datatype Length Mandatory Comments
ACTION_ID NUMBER
Yes 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
DESCRIPTION VARCHAR2 (80) Yes Action description
ONLINE_FLAG NUMBER
Yes Online or background action indicator flag
ENABLED_FLAG NUMBER
Yes Flag to enable or disable action. A value of 1 means action is enabled, 2 means action is disabled.
Query Text

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


SELECT ACTION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DESCRIPTION
,      ONLINE_FLAG
,      ENABLED_FLAG
FROM QA.QA_ACTIONS;

Dependencies

[top of page]

QA.QA_ACTIONS does not reference any database object

QA.QA_ACTIONS is referenced by following:

SchemaAPPS
SynonymQA_ACTIONS