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_CRITERIA

Object Details

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

QA_CRITERIA is used to store "show results where" information to
retrieve specific values from collected results. QA_CRITERIA is used
by Oracle Quality's charts, Dynamic Reportwriter, and descriptive
statistics functionality.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QA_CRITERIA_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CRITERIA_SEQUENCE
QA_CRITERIA_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CRITERIA_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CRITERIA_SEQUENCE	NUMBER		Yes	Identifies criteria
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
CRITERIA_ID	NUMBER		Yes	Identifes criteria header in the table QA_CRITERIA_HEADER
ORDER_SEQUENCE	NUMBER			Sequence in which collection elements appear in the criteria definitions
SQL_TYPE	NUMBER		Yes	Indicates if collection element will appear in report body or if it will be used as selection criteria for the report
CHAR_ID	NUMBER		Yes	Collection element Identifier
OPERATOR	NUMBER			Operator used in defining the selection criteria
LOW_VALUE	VARCHAR2	(150)		Lower limit for the collection element value range used in defining criteria
LOW_VALUE_ID	NUMBER			Identifies Flexfield ID for collection elements that are flexfields
HIGH_VALUE	VARCHAR2	(150)		Upper limit to the collection element value range user wish to retrieve
HIGH_VALUE_ID	NUMBER			Identifies flexfield ID for collection elements that are flexfields
FXN	NUMBER			Function applied to the collection element
TOTAL	NUMBER			Indicates if collection element total is to be reported
SORT_BY	NUMBER			No longer used

Query Text

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


SELECT CRITERIA_SEQUENCE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CRITERIA_ID
,      ORDER_SEQUENCE
,      SQL_TYPE
,      CHAR_ID
,      OPERATOR
,      LOW_VALUE
,      LOW_VALUE_ID
,      HIGH_VALUE
,      HIGH_VALUE_ID
,      FXN
,      TOTAL
,      SORT_BY
FROM QA.QA_CRITERIA;

Dependencies

[top of page]

QA.QA_CRITERIA does not reference any database object

QA.QA_CRITERIA is referenced by following:

QA: QA_CRITERIA#