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_CONTROL_LIMITS

Object Details

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

QA_CONTROL_LIMITS contains control chart limit information that will
be associated with a control chart for the specified collection element.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QA_CONTROL_LIMITS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CONTROL_LIMIT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CONTROL_LIMIT_ID	NUMBER		Yes	Control limit 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
CHAR_ID	NUMBER		Yes	Collection element Identifier
PLAN_ID	NUMBER			Collection plan Identifier
SPEC_ID	NUMBER			Specification Identifier
CRITERIA_ID	NUMBER			Criteria Identifier
CHART_TYPE	NUMBER		Yes	Type of control chart
NAME	VARCHAR2	(100)	Yes	Name of the control chart
DESCRIPTION	VARCHAR2	(240)		Description of the control chart
SUBGROUP_SIZE	NUMBER		Yes	This field is used only for X bar R chart. This is used to calculate the control limits
NUMBER_SUBGROUPS	NUMBER			Number of subgroups
LCL	NUMBER		Yes	Lower control limit for top part of the control chart
UCL	NUMBER		Yes	Upper control limit for the top part of the chart
TARGET	NUMBER		Yes	Target control limit for the top part of the chart
R_LCL	NUMBER		Yes	Lower control limit for bottom part of the control chart
R_UCL	NUMBER		Yes	Upper control limit for the bottom part of the chart
R_TARGET	NUMBER		Yes	Target control limit for the bottom part of the chart

Query Text

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


SELECT CONTROL_LIMIT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CHAR_ID
,      PLAN_ID
,      SPEC_ID
,      CRITERIA_ID
,      CHART_TYPE
,      NAME
,      DESCRIPTION
,      SUBGROUP_SIZE
,      NUMBER_SUBGROUPS
,      LCL
,      UCL
,      TARGET
,      R_LCL
,      R_UCL
,      R_TARGET
FROM QA.QA_CONTROL_LIMITS;

Dependencies

[top of page]

QA.QA_CONTROL_LIMITS does not reference any database object

QA.QA_CONTROL_LIMITS is referenced by following:

APPS: QA_CONTROL_LIMITS