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]

TABLE: QA.QA_SEQ_AUDIT_HISTORY

Object Details

Object Name:	QA_SEQ_AUDIT_HISTORY
Object Type:	TABLE
Owner:	QA
FND Design Data:	QA.QA_SEQ_AUDIT_HISTORY
Subobject Name:
Status:	VALID

To keep track of generated sequencs and their current statuses. Necessary to generate reports to show sequences are gapless.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QA_SEQ_AUDIT_HISTORY_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHAR_ID SEQUENCE_VALUE
QA_SEQ_AUDIT_HISTORY_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AUDIT_DATE
QA_SEQ_AUDIT_HISTORY_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TXN_HEADER_ID
QA_SEQ_AUDIT_HISTORY_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COLLECTION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PLAN_ID	NUMBER		Yes	plan ID
COLLECTION_ID	NUMBER		Yes	collection ID
OCCURRENCE	NUMBER		Yes	occurrence
CHAR_ID	NUMBER		Yes	element ID
TXN_HEADER_ID	NUMBER			txn header ID
SEQUENCE_VALUE	VARCHAR2	(50)	Yes	sequence value to be tracked
USER_ID	NUMBER		Yes	user ID of the user who initiated the action
SOURCE_CODE	VARCHAR2	(30)		identifies the source of the transaction
SOURCE_ID	NUMBER			intended to store fk references to documents that contain this sequence
AUDIT_TYPE	VARCHAR2	(30)	Yes	audit type such as CREATED, REJECTED, DELETED
AUDIT_DATE	DATE		Yes	audit date/time
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
,      COLLECTION_ID
,      OCCURRENCE
,      CHAR_ID
,      TXN_HEADER_ID
,      SEQUENCE_VALUE
,      USER_ID
,      SOURCE_CODE
,      SOURCE_ID
,      AUDIT_TYPE
,      AUDIT_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM QA.QA_SEQ_AUDIT_HISTORY;

Dependencies

[top of page]

QA.QA_SEQ_AUDIT_HISTORY does not reference any database object

QA.QA_SEQ_AUDIT_HISTORY is referenced by following:

QA: QA_SEQ_AUDIT_HISTORY#