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_RCV_RESULTS

Object Details

Object Name:	QA_SKIPLOT_RCV_RESULTS
Object Type:	TABLE
Owner:	QA
FND Design Data:	QA.QA_SKIPLOT_RCV_RESULTS
Subobject Name:
Status:	VALID

Skip Lot Inspection Results for Receiving

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QA_SKIPLOT_RCV_RESULTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	INSP_LOT_ID
QA_SKIPLOT_RCV_RESULTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INTERFACE_TXN_ID
QA_SKIPLOT_RCV_RESULTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SHIPMENT_LINE_ID
QA_SKIPLOT_RCV_RESULTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CRITERIA_ID
QA_SKIPLOT_RCV_RESULTS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LPN_ID

Columns

Name	Datatype	Length	Mandatory	Comments
INSP_LOT_ID	NUMBER		Yes	Primary key
CRITERIA_ID	NUMBER		Yes	foreign key to Skip Lot/Sampling Criteria
PROCESS_ID	NUMBER			foreign key to skip lot processes
INTERFACE_TXN_ID	NUMBER		Yes	Temporary surrogate key to identify the transaction in the interface table
SHIPMENT_LINE_ID	NUMBER			Shipment Line ID generated by Receiving Transaction Processor
RECEIPT_DATE	DATE		Yes	Receipt Date
MANUFACTURER_ID	NUMBER			Manufacturer ID
SOURCE_INSPECTED	VARCHAR2	(1)		Source Inspected Flag
LOT_QTY	NUMBER		Yes	Lot Quantity
TRANSACTED_QTY	NUMBER			Transacted quantity
INSPECTION_STATUS	VARCHAR2	(20)	Yes	Inspection status
INSPECTION_RESULT	VARCHAR2	(20)		Inspection result
LAST_INSP_DATE	DATE			Last inspection date
VALID_FLAG	NUMBER			Valid flag
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
LPN_ID	NUMBER			LPN ID

Query Text

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


SELECT INSP_LOT_ID
,      CRITERIA_ID
,      PROCESS_ID
,      INTERFACE_TXN_ID
,      SHIPMENT_LINE_ID
,      RECEIPT_DATE
,      MANUFACTURER_ID
,      SOURCE_INSPECTED
,      LOT_QTY
,      TRANSACTED_QTY
,      INSPECTION_STATUS
,      INSPECTION_RESULT
,      LAST_INSP_DATE
,      VALID_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LPN_ID
FROM QA.QA_SKIPLOT_RCV_RESULTS;

Dependencies

[top of page]

QA.QA_SKIPLOT_RCV_RESULTS does not reference any database object

QA.QA_SKIPLOT_RCV_RESULTS is referenced by following:

QA: QA_SKIPLOT_RCV_RESULTS#