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_ACTION_LOG_V

Object Details

Object Name:	QA_ACTION_LOG_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	QA.QA_ACTION_LOG_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
LOG_ID	NUMBER		Yes	Action log ientifier
ROW_ID	ROWID	(10)		Table row 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
REQUEST_ID	NUMBER			Concurrent request identifier
PROGRAM_APPLICATION_ID	NUMBER			Application identifier
PROGRAM_ID	NUMBER			Concurrent program identifier
PROGRAM_UPDATE_DATE	DATE			Date this record was created or updated
PLAN_ID	NUMBER		Yes	collection plan identifier
PLAN_NAME	VARCHAR2	(30)	Yes	Collection plan name
COLLECTION_ID	NUMBER		Yes	Result collection identifier in table QA_RESULTS
TRANSACTION_DATE	DATE		Yes	Log creation date
CHAR_ID	NUMBER		Yes	Collection element identifier
CHAR_NAME	VARCHAR2	(30)	Yes	Collection element name
OPERATOR	NUMBER		Yes	Comparision operator used in defining action trigger
OPERATOR_MEANING	VARCHAR2	(80)	Yes	Meaning of the operator
LOW_VALUE	VARCHAR2	(150)		Collection element low value for action trigger
LOW_VALUE_ID	NUMBER			Low value identifier
HIGH_VALUE	VARCHAR2	(150)		Collection element high value for action trigger
HIGH_VALUE_ID	NUMBER			High value identifier
ACTION_LOG_MESSAGE	VARCHAR2	(4000)		Log message for action executed
RESULT_VALUE	VARCHAR2	(150)		Collection element value as entered by user
RESULT_VALUE_ID	NUMBER			Result value identifier
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfiedl segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment

Query Text

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


SELECT LOG_ID
,      ROW_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PLAN_ID
,      PLAN_NAME
,      COLLECTION_ID
,      TRANSACTION_DATE
,      CHAR_ID
,      CHAR_NAME
,      OPERATOR
,      OPERATOR_MEANING
,      LOW_VALUE
,      LOW_VALUE_ID
,      HIGH_VALUE
,      HIGH_VALUE_ID
,      ACTION_LOG_MESSAGE
,      RESULT_VALUE
,      RESULT_VALUE_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM APPS.QA_ACTION_LOG_V;

Dependencies

[top of page]

APPS.QA_ACTION_LOG_V references the following:

APPS: MFG_LOOKUPS; QA_ACTION_LOG; QA_CHARS; QA_PLANS

APPS.QA_ACTION_LOG_V is not referenced by any database object