DBA Data[Home] [Help] [Dependency Information]

TABLE: QA.QA_CHART_CONTROL

Object Details
Object Name: QA_CHART_CONTROL
Object Type: TABLE
Owner: QA
FND Design Data: TableQA.QA_CHART_CONTROL
Subobject Name:
Status: VALID


Special charting table for control chart type.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
QA_CHART_CONTROL_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCHART_ID
ColumnLINE
Columns
Name Datatype Length Mandatory Comments
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
CHART_ID NUMBER
Yes Chart ID, Primary Key
LINE NUMBER
Yes Unique line number for a given chart, used as ORDER BY.
X_VALUE VARCHAR2 (150) Yes x-axis ticker labels
TOP_Y_VALUE NUMBER
Yes y-axis numeric values for top graph.
TOP_UCL_VALUE NUMBER
Yes Upper control limit for top graph.
TOP_MEAN_VALUE NUMBER
Yes Mean value (center line) for top graph.
TOP_LCL_VALUE NUMBER
Yes Lower control limit for top graph.
BOTTOM_Y_VALUE NUMBER
Yes y-axis numeric value for bottom graph.
BOTTOM_UCL_VALUE NUMBER
Yes Upper control limit for bottom graph.
BOTTOM_MEAN_VALUE NUMBER
Yes Mean value (center line) of bottom graph.
BOTTOM_LCL_VALUE NUMBER
Yes Lower control limit of bottom graph.
Query Text

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


SELECT CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CHART_ID
,      LINE
,      X_VALUE
,      TOP_Y_VALUE
,      TOP_UCL_VALUE
,      TOP_MEAN_VALUE
,      TOP_LCL_VALUE
,      BOTTOM_Y_VALUE
,      BOTTOM_UCL_VALUE
,      BOTTOM_MEAN_VALUE
,      BOTTOM_LCL_VALUE
FROM QA.QA_CHART_CONTROL;

Dependencies

[top of page]

QA.QA_CHART_CONTROL does not reference any database object

QA.QA_CHART_CONTROL is referenced by following:

SchemaQA
ViewQA_CHART_CONTROL#