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

TABLE: QA.QA_SKIPLOT_STATE_HISTORY

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


Skip Lot Inspection History


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
QA_SKIPLOT_STATE_HISTORY_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROCESS_PLAN_ID
ColumnCRITERIA_ID
Columns
Name Datatype Length Mandatory Comments
PROCESS_PLAN_ID NUMBER
Yes foreign key to Skip Lot Process Plans
CRITERIA_ID NUMBER
Yes foreign key to Skip Lot/Sampling Criteria
CHANGE_DATE DATE
Yes Timestamp
OLD_FREQ_NUM NUMBER

Old frequency numerator
OLD_FREQ_DENOM NUMBER

Old frequency denominator
NEW_FREQ_NUM NUMBER
Yes new frequency numerator
NEW_FREQ_DENOM NUMBER
Yes New frequency denominator
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
Query Text

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


SELECT PROCESS_PLAN_ID
,      CRITERIA_ID
,      CHANGE_DATE
,      OLD_FREQ_NUM
,      OLD_FREQ_DENOM
,      NEW_FREQ_NUM
,      NEW_FREQ_DENOM
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM QA.QA_SKIPLOT_STATE_HISTORY;

Dependencies

[top of page]

QA.QA_SKIPLOT_STATE_HISTORY does not reference any database object

QA.QA_SKIPLOT_STATE_HISTORY is referenced by following:

SchemaAPPS
SynonymQA_SKIPLOT_STATE_HISTORY