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_SEQ_AUDIT_HISTORY_V

Object Details

Object Name:	QA_SEQ_AUDIT_HISTORY_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	QA.QA_SEQ_AUDIT_HISTORY_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
PLAN_ID	NUMBER		Yes	plan ID
PLAN_NAME	VARCHAR2	(30)	Yes	plan name
PLAN_DESCRIPTION	VARCHAR2	(150)		plan description
ORGANIZATION_ID	NUMBER		Yes	organization ID
ORGANIZATION_CODE	VARCHAR2	(3)		organization code
COLLECTION_ID	NUMBER		Yes	collection ID
OCCURRENCE	NUMBER		Yes	occurrence
CHAR_ID	NUMBER		Yes	element ID
CHAR_NAME	VARCHAR2	(30)	Yes	element name
SEQUENCE_VALUE	VARCHAR2	(50)	Yes	the generated sequence value
TXN_HEADER_ID	NUMBER			txn header ID
USER_ID	NUMBER		Yes	user ID
USER_NAME	VARCHAR2	(100)	Yes	user name
SOURCE_CODE	VARCHAR2	(30)		source code
SOURCE_ID	NUMBER			source ID
AUDIT_TYPE	VARCHAR2	(30)	Yes	audit type
AUDIT_TYPE_MEANING	VARCHAR2	(80)	Yes	audit type meaning
AUDIT_TYPE_DESCRIPTION	VARCHAR2	(240)		audit type description
AUDIT_DATE	DATE		Yes	audit date
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

Query Text

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


SELECT PLAN_ID
,      PLAN_NAME
,      PLAN_DESCRIPTION
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      COLLECTION_ID
,      OCCURRENCE
,      CHAR_ID
,      CHAR_NAME
,      SEQUENCE_VALUE
,      TXN_HEADER_ID
,      USER_ID
,      USER_NAME
,      SOURCE_CODE
,      SOURCE_ID
,      AUDIT_TYPE
,      AUDIT_TYPE_MEANING
,      AUDIT_TYPE_DESCRIPTION
,      AUDIT_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM APPS.QA_SEQ_AUDIT_HISTORY_V;

Dependencies

[top of page]

APPS.QA_SEQ_AUDIT_HISTORY_V references the following:

APPS: FND_USER; MTL_PARAMETERS; QA_CHARS; QA_LOOKUPS; QA_PLANS; QA_SEQ_AUDIT_HISTORY

APPS.QA_SEQ_AUDIT_HISTORY_V is not referenced by any database object