[Home] [Help] [Dependency Information]
Object Name: | QA_CHAR_ACTIONS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | QA.QA_CHAR_ACTIONS_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | QA_CHAR_ACTION row identifier | |
CHAR_ACTION_ID | NUMBER | Yes | Collection element 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 | ||
CHAR_ACTION_TRIGGER_ID | NUMBER | Yes | Collection element Action trigger identifier | |
ACTION_ID | NUMBER | Yes | Action identifier | |
ACTION_DESCRIPTION | VARCHAR2 | (80) | Yes | Action description |
TRIGGER_SEQUENCE | NUMBER | Yes | Action trigger sequence | |
CAR_NAME_PREFIX | VARCHAR2 | (20) | Corrective action data to be used in future | |
CAR_TYPE_ID | NUMBER | Corrective action data to be used in future | ||
CAR_TYPE_NAME | VARCHAR2 | (0) | Corrective action data to be used in future | |
CAR_OWNER | NUMBER | Corrective action data to be used in future | ||
CAR_OWNER_NAME | VARCHAR2 | (0) | Corrective action data to be used in future | |
MESSAGE | VARCHAR2 | (240) | This field stores the action detail. For example, this field stores the actualmessage for 'display a message to the operator' action. | |
STATUS_CODE | VARCHAR2 | (30) | Stores the status code for some of the quality actions. | |
STATUS_ID | NUMBER | Status identifier | ||
CHAR_ID | NUMBER | Yes | Collection element identifier | |
CHAR_NAME | VARCHAR2 | (30) | Yes | Collection element name |
ALR_ACTION_SET_ID | NUMBER | Alert action set identifier | ||
ALR_ACTION_ID | NUMBER | Alert action identifier |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, CHAR_ACTION_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, CHAR_ACTION_TRIGGER_ID
, ACTION_ID
, ACTION_DESCRIPTION
, TRIGGER_SEQUENCE
, CAR_NAME_PREFIX
, CAR_TYPE_ID
, CAR_TYPE_NAME
, CAR_OWNER
, CAR_OWNER_NAME
, MESSAGE
, STATUS_CODE
, STATUS_ID
, CHAR_ID
, CHAR_NAME
, ALR_ACTION_SET_ID
, ALR_ACTION_ID
FROM APPS.QA_CHAR_ACTIONS_V;
APPS.QA_CHAR_ACTIONS_V is not referenced by any database object
|
|
|