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: GMD.QC_SMPL_MST

Object Details

Object Name:	QC_SMPL_MST
Object Type:	TABLE
Owner:	GMD
FND Design Data:	GMD.QC_SMPL_MST
Subobject Name:
Status:	VALID

QC sample master. Contains sample information, including what, when, where, who, and how much.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QC_SMPL_MST_PK	NORMAL	UNIQUE	APPS_TS_ARCHIVE	SAMPLE_ID
QC_SMPL_MST_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	FORMULALINE_ID
QC_SMPL_MST_N2	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	ITEM_ID LOT_ID
QC_SMPL_MST_N3	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	SAMPLE_NO

Columns

Name	Datatype	Length	Mandatory	Comments
SAMPLE_ID	NUMBER	(10)	Yes	Surrogate key for the sample.
ORGN_CODE	VARCHAR2	(4)	Yes	Organization for which the sample is drawn.
SAMPLE_NO	VARCHAR2	(32)	Yes	Sample number.
SAMPLE_DESC	VARCHAR2	(70)		Sample description.
BATCH_ID	NUMBER	(10)		Surrogate key for the batch from which the sample was drawn.
FORMULA_ID	NUMBER	(10)		Surrogate key for the formula.
FORMULALINE_ID	NUMBER	(10)		Surrogate key for the formula line.
ROUTING_ID	NUMBER	(10)		Surrogate key for the routing.
ROUTINGSTEP_ID	NUMBER	(10)		Surrogate key for the routing step.
OPRN_ID	NUMBER	(10)		Surrogate key for the operation.
ITEM_ID	NUMBER	(10)	Yes	Surrogate key for the item sampled.
LOT_ID	NUMBER	(10)		Surrogate key for the lot/sublot sampled.
WHSE_CODE	VARCHAR2	(4)		Warehouse in which the item was sampled.
LOCATION	VARCHAR2	(16)		Location in which the item was sampled.
CUST_ID	NUMBER	(15)		Surrogate key for the customer for whom the item was sampled.
VENDOR_ID	NUMBER	(10)		Surrogate key for the vendor for which the item was sampled.
SAMPLE_DATE	DATE		Yes	Date on which the sample was drawn.
SAMPLED_BY	NUMBER	(15)	Yes	Operator who drew the sample.
SAMPLE_QTY	NUMBER		Yes	Quantity of material sampled.
SAMPLE_UM	VARCHAR2	(4)	Yes	Units of the sampled quantity.
EXTERNAL_ID	VARCHAR2	(32)		Alternate sample name.
DELETE_MARK	NUMBER	(5)	Yes	Standard: 0=Active record (default); 1=Marked for (logical) deletion.
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
TRANS_CNT	NUMBER	(10)		Not currently used
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
ROUTINGSTEP_NO	NUMBER	(5)		Routing Step Number
SAMPLE_STATUS	VARCHAR2	(80)	Yes	Disposition of sample (e.g. ACCEPTED)
SAMPLE_FINAL_APPROVER	VARCHAR2	(30)		Final Sample Approver
SAMPLE_TEST_APPROVER	VARCHAR2	(30)		Sample Test Approver
ATTRIBUTE1	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE2	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE3	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE4	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE5	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE6	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE7	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE8	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE9	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE10	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE11	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE12	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE13	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE14	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE15	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE16	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE17	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE18	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE19	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE20	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE21	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE22	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE23	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE24	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE25	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE26	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE27	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE28	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE29	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE30	VARCHAR2	(240)		Descriptive Flexfield Segment
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield Segment
CHARGE	NUMBER			Charge
OPM_CUST_ID	NUMBER	(10)		Used by OM users only. Stores customer id to op_cust_mst (OPM customer table) for historical purposes.
STORAGE_WHSE	VARCHAR2	(4)		Whse code for whse where samples are stored.
STORAGE_LOCATION	VARCHAR2	(16)		Location code where samples are stored, or if whse if null, free-form text representing the sample location
SAMPLE_SOURCE	VARCHAR2	(70)		Free-form text (for now) representing where a sample came from - inventory, customer return, vendor sample,production line, etc.
ORDER_HEADER_ID	NUMBER			Order ID used for order-specific customer samples. FK =OE_ORDER_HEADERS_ALL.header_id
ORDER_LINE	VARCHAR2	(16)		Concatenated order line number used for order-line-specific customer samples. Corresponds to what user sees on Orders forms.
ORDER_LINE_ID	NUMBER			Order line ID used for order-line-specific customer samples. FK =OE_ORDER_LINES_ALL.line_id
ORDER_ORG_ID	NUMBER			Operating unit id used for order-specific customer results
QC_REC_TYPE	VARCHAR2	(4)		Indicator for item/loc vs customer vs supplier vs production samples. Should help performance.
SHIP_TO_SITE_ID	NUMBER			Ship-to ID/cust-site used for order-specific customer results. FK =OE_ORDER_HEADERS.ALL.header_id
MIGRATION_STATUS	VARCHAR2	(4)		Record migration status

Query Text

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


SELECT SAMPLE_ID
,      ORGN_CODE
,      SAMPLE_NO
,      SAMPLE_DESC
,      BATCH_ID
,      FORMULA_ID
,      FORMULALINE_ID
,      ROUTING_ID
,      ROUTINGSTEP_ID
,      OPRN_ID
,      ITEM_ID
,      LOT_ID
,      WHSE_CODE
,      LOCATION
,      CUST_ID
,      VENDOR_ID
,      SAMPLE_DATE
,      SAMPLED_BY
,      SAMPLE_QTY
,      SAMPLE_UM
,      EXTERNAL_ID
,      DELETE_MARK
,      TEXT_CODE
,      TRANS_CNT
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      ROUTINGSTEP_NO
,      SAMPLE_STATUS
,      SAMPLE_FINAL_APPROVER
,      SAMPLE_TEST_APPROVER
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      ATTRIBUTE_CATEGORY
,      CHARGE
,      OPM_CUST_ID
,      STORAGE_WHSE
,      STORAGE_LOCATION
,      SAMPLE_SOURCE
,      ORDER_HEADER_ID
,      ORDER_LINE
,      ORDER_LINE_ID
,      ORDER_ORG_ID
,      QC_REC_TYPE
,      SHIP_TO_SITE_ID
,      MIGRATION_STATUS
FROM GMD.QC_SMPL_MST;

Dependencies

[top of page]

GMD.QC_SMPL_MST does not reference any database object

GMD.QC_SMPL_MST is referenced by following:

GMD: QC_SMPL_MST#