[Home] [Help] [Dependency Information]
Object Name: | QA_CHART_HEADERS |
---|---|
Object Type: | TABLE |
Owner: | QA |
FND Design Data: | QA.QA_CHART_HEADERS |
Subobject Name: | |
Status: | VALID |
Table to keep an instance of a chart to be plotted.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
QA_CHART_HEADERS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | CHART_ID |
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 | |
CRITERIA_ID | NUMBER | Foreign key to qa_criteria_headers if not null. | ||
TITLE | VARCHAR2 | (150) | Primary Chart Title | |
DESCRIPTION | VARCHAR2 | (250) | Chart Description | |
X_LABEL | VARCHAR2 | (150) | x-axis Label | |
Y_LABEL | VARCHAR2 | (150) | y-axis Label | |
UPPER_SPEC_LIMIT | NUMBER | Upper spec limit | ||
LOWER_SPEC_LIMIT | NUMBER | Lower Spec Limit | ||
TARGET_VALUE | NUMBER | Target value | ||
CP | NUMBER | Process capability Cp | ||
CPK | NUMBER | Process capability Cpk | ||
UOM_CODE | VARCHAR2 | (3) | Specification UOM Code |
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
, CRITERIA_ID
, TITLE
, DESCRIPTION
, X_LABEL
, Y_LABEL
, UPPER_SPEC_LIMIT
, LOWER_SPEC_LIMIT
, TARGET_VALUE
, CP
, CPK
, UOM_CODE
FROM QA.QA_CHART_HEADERS;
QA.QA_CHART_HEADERS does not reference any database object
QA.QA_CHART_HEADERS is referenced by following:
|
|
|