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

TABLE: QA.QA_CHART_HEADERS

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


Table to keep an instance of a chart to be plotted.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
QA_CHART_HEADERS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCHART_ID
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
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
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
,      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;

Dependencies

[top of page]

QA.QA_CHART_HEADERS does not reference any database object

QA.QA_CHART_HEADERS is referenced by following:

SchemaAPPS
SynonymQA_CHART_HEADERS