[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
GMD.QC_SMPL_MST does not reference any database object
GMD.QC_SMPL_MST is referenced by following:
|
|
|