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_HEADERS

Object Details

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

QA_CRITERIA_HEADERS is used to store use- defined charts, descriptive
statistics, and settings for the Dynamic Reportwriter. It has a
master-detail relationship with QA_CRITERIA.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QA_CRITERIA_HEADERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CRITERIA_ID
QA_CRITERIA_HEADERS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID NAME OUTPUT_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
CRITERIA_ID	NUMBER		Yes	Criteria 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
NAME	VARCHAR2	(30)	Yes	Criteria name
PLAN_ID	NUMBER			Identifies collection plan to which criteria is applied
ORGANIZATION_ID	NUMBER			Inventory organization Identifier
OUTPUT_TYPE	NUMBER		Yes	Indicates the type of the chart or report to which criteria is defined
TITLE	VARCHAR2	(50)		Chart or report title
DESCRIPTION	VARCHAR2	(225)		Chart or report description
CHART_TYPE	NUMBER			Control chart type
NUM_BARS	NUMBER			Number of bars in histogram
NUM_POINTS	NUMBER			Number of points in histogram
X_AXIS_CHAR_ID	NUMBER			Collection element that is to be plotted on x-axis
Y_AXIS_CHAR_ID	NUMBER			Collection element that is to be plotted on y-axis
Y_AXIS_FXN	NUMBER			Function applied to calculate Y_AXIS values
TOP_N_GROUPS	NUMBER			Number of groups user wants to display in pareto chart
X_AXIS_GROUP_BY_ID	NUMBER			Grouping element of X-AXIS. This information is used only for trend charts
SPEC_ID	NUMBER			Specification identifier to be used in histograms
TARGET_VALUE_FLAG	NUMBER			Flag to indicate if specification target value should be used in histograms
SPEC_LIMIT_FLAG	NUMBER			Flag to indicate if specification limits should be used in histograms
USER_DEFINED_LIMIT_FLAG	NUMBER			Flag to indicate if user defined limit to be used in histograms

Query Text

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


SELECT CRITERIA_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      NAME
,      PLAN_ID
,      ORGANIZATION_ID
,      OUTPUT_TYPE
,      TITLE
,      DESCRIPTION
,      CHART_TYPE
,      NUM_BARS
,      NUM_POINTS
,      X_AXIS_CHAR_ID
,      Y_AXIS_CHAR_ID
,      Y_AXIS_FXN
,      TOP_N_GROUPS
,      X_AXIS_GROUP_BY_ID
,      SPEC_ID
,      TARGET_VALUE_FLAG
,      SPEC_LIMIT_FLAG
,      USER_DEFINED_LIMIT_FLAG
FROM QA.QA_CRITERIA_HEADERS;

Dependencies

[top of page]

QA.QA_CRITERIA_HEADERS does not reference any database object

QA.QA_CRITERIA_HEADERS is referenced by following:

APPS: QA_CRITERIA_HEADERS