[Home] [Help] [Dependency Information]
Object Name: | QA_SKIPLOT_LOT_PLANS |
---|---|
Object Type: | TABLE |
Owner: | QA |
FND Design Data: | QA.QA_SKIPLOT_LOT_PLANS |
Subobject Name: | |
Status: | VALID |
Skip Lot Lot-Inspection Results per Plan
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
QA_SKIPLOT_LOT_PLANS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
INSP_LOT_ID
PLAN_ID |
QA_SKIPLOT_LOT_PLANS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | COLLECTION_ID |
QA_SKIPLOT_LOT_PLANS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SHIPMENT_LINE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INSP_LOT_ID | NUMBER | Yes | foreign key to Skip Lot Results | |
PLAN_ID | NUMBER | Yes | foreign key to collection plans | |
COLLECTION_ID | NUMBER | foreign key to result collection id | ||
ALTERNATE_FLAG | VARCHAR2 | (1) | Yes | Alternate plan flag |
SHIPMENT_LINE_ID | NUMBER | foreign key to shipment lines | ||
PLAN_INSP_STATUS | VARCHAR2 | (20) | Yes | Inspection status |
PLAN_INSP_RESULT | VARCHAR2 | (20) | Inspection result | |
SAMPLE_SIZE | NUMBER | Sample size | ||
INSPECTED_QTY | NUMBER | Inspected quantity | ||
ACCEPTED_QTY | NUMBER | Quantity accepted | ||
REJECTED_QTY | NUMBER | Quantity rejected | ||
LAST_INSP_DATE | DATE | Timestamp | ||
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 |
Cut, paste (and edit) the following text to query this object:
SELECT INSP_LOT_ID
, PLAN_ID
, COLLECTION_ID
, ALTERNATE_FLAG
, SHIPMENT_LINE_ID
, PLAN_INSP_STATUS
, PLAN_INSP_RESULT
, SAMPLE_SIZE
, INSPECTED_QTY
, ACCEPTED_QTY
, REJECTED_QTY
, LAST_INSP_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
FROM QA.QA_SKIPLOT_LOT_PLANS;
QA.QA_SKIPLOT_LOT_PLANS does not reference any database object
QA.QA_SKIPLOT_LOT_PLANS is referenced by following:
|
|
|