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]

VIEW: APPS.QA_CHAR_ACTIONS_V

Object Details

Object Name:	QA_CHAR_ACTIONS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	QA.QA_CHAR_ACTIONS_V
Subobject Name:
Status:	VALID

View Type

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.

[View Source]

Columns

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

Query Text

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;

Dependencies

[top of page]

APPS.QA_CHAR_ACTIONS_V references the following:

APPS: QA_ACTIONS; QA_CHARS; QA_CHAR_ACTIONS; QA_CHAR_ACTION_TRIGGERS

APPS.QA_CHAR_ACTIONS_V is not referenced by any database object