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

TABLE: QA.QA_SKIPLOT_PLAN_STATES

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


Skip Lot Process Plan States


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
QA_SKIPLOT_PLAN_STATES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROCESS_PLAN_ID
ColumnCRITERIA_ID
QA_SKIPLOT_PLAN_STATES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCRITERIA_ID
Columns
Name Datatype Length Mandatory Comments
PROCESS_PLAN_ID NUMBER
Yes foreign key to Skip Lot Process Plan
CRITERIA_ID NUMBER
Yes foreign key to Skip Lot/Sampling Criteria
CURRENT_RULE NUMBER
Yes Current rule sequence
CURRENT_ROUND NUMBER
Yes Current Round number
CURRENT_LOT NUMBER
Yes Current Lot
LAST_RECEIPT_LOT_ID NUMBER
Yes Last Receipt Lot ID
LAST_RECEIPT_DATE DATE

Last Receipt Date
LOT_ACCEPTED NUMBER
Yes Is lot accepted or rejected
RULE_START_LOT_ID NUMBER

Lot ID when rule started.
RULE_START_DATE DATE

Start date of skipping rule
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
,      CURRENT_RULE
,      CURRENT_ROUND
,      CURRENT_LOT
,      LAST_RECEIPT_LOT_ID
,      LAST_RECEIPT_DATE
,      LOT_ACCEPTED
,      RULE_START_LOT_ID
,      RULE_START_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM QA.QA_SKIPLOT_PLAN_STATES;

Dependencies

[top of page]

QA.QA_SKIPLOT_PLAN_STATES does not reference any database object

QA.QA_SKIPLOT_PLAN_STATES is referenced by following:

SchemaAPPS
SynonymQA_SKIPLOT_PLAN_STATES