eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: QA.QA_SKIPLOT_LOT_PLANS

Object Details

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

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

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

Columns

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

Query Text

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;

Dependencies

[top of page]

QA.QA_SKIPLOT_LOT_PLANS does not reference any database object

QA.QA_SKIPLOT_LOT_PLANS is referenced by following:

QA: QA_SKIPLOT_LOT_PLANS#