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_PLAN_CHAR_ACTIONS_V

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Identifies row in the table QA_PLAN_CHA_ACTIONS
PLAN_CHAR_ACTION_ID	NUMBER		Yes	Unique identifier to PLAN_CHAR_ACTION table.
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
TRIGGER_SEQUENCE	NUMBER		Yes	Sequence number of trigger. This sequence is used to evaluate trigger priority.
ACTION_ID	NUMBER		Yes	Action identifier
ACTION_DESCRIPTION	VARCHAR2	(80)	Yes	Action description
CAR_NAME_PREFIX	VARCHAR2	(20)		This column will be used for corrective action functionality
CAR_TYPE_ID	NUMBER			This column will be used for corrective action functionality
CAR_TYPE_NAME	VARCHAR2	(0)		This column will be used for corrective action functionality
CAR_OWNER	NUMBER			This column will be used for corrective action functionality
CAR_OWNER_NAME	VARCHAR2	(0)		This column will be used for corrective action functionality
MESSAGE	VARCHAR2	(2000)		Action message or action details for the action.
STATUS_CODE	VARCHAR2	(30)		Status code to be assigned for the acion
STATUS_ID	NUMBER			Status identifier
ALR_ACTION_SET_ID	NUMBER			Alert action set identifier
ALR_ACTION_ID	NUMBER			Alert action identifer
ASSIGNED_CHAR_ID	NUMBER			Collection element to which a value will be assigned using action.
ASSIGNED_CHAR_NAME	VARCHAR2	(30)		Name of the collection element to which value will be assigned
ASSIGN_TYPE	VARCHAR2	(1)		user defined method to assign a value
PLAN_ID	NUMBER		Yes	Collection plan identifier
PLAN_NAME	VARCHAR2	(30)	Yes	Collection plan name
CHAR_ID	NUMBER		Yes	Collection element identifier
CHAR_NAME	VARCHAR2	(30)	Yes	Collection element name

Query Text

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


SELECT ROW_ID
,      PLAN_CHAR_ACTION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PLAN_CHAR_ACTION_TRIGGER_ID
,      TRIGGER_SEQUENCE
,      ACTION_ID
,      ACTION_DESCRIPTION
,      CAR_NAME_PREFIX
,      CAR_TYPE_ID
,      CAR_TYPE_NAME
,      CAR_OWNER
,      CAR_OWNER_NAME
,      MESSAGE
,      STATUS_CODE
,      STATUS_ID
,      ALR_ACTION_SET_ID
,      ALR_ACTION_ID
,      ASSIGNED_CHAR_ID
,      ASSIGNED_CHAR_NAME
,      ASSIGN_TYPE
,      PLAN_ID
,      PLAN_NAME
,      CHAR_ID
,      CHAR_NAME
FROM APPS.QA_PLAN_CHAR_ACTIONS_V;

Dependencies

[top of page]

APPS.QA_PLAN_CHAR_ACTIONS_V references the following:

APPS: QA_ACTIONS; QA_CHARS; QA_PLANS; QA_PLAN_CHAR_ACTIONS; QA_PLAN_CHAR_ACTION_TRIGGERS

APPS.QA_PLAN_CHAR_ACTIONS_V is referenced by following:

APPS: QLTCPDFB - show dependent code