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

TABLE: GMD.QC_RSLT_MST

Object Details
Object Name: QC_RSLT_MST
Object Type: TABLE
Owner: GMD
FND Design Data: TableGMD.QC_RSLT_MST
Subobject Name:
Status: VALID


QC results master. Results of tests against QC assays. Results can be
either for an item/location, a customer, a vendor, or a batch.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
QC_RSLT_MST_PK NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnQC_RESULT_ID
QC_RSLT_MSTI1 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnITEM_ID
ColumnLOT_ID
ColumnWHSE_CODE
ColumnLOCATION
ColumnASSAY_CODE
QC_RSLT_MSTI2 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnSAMPLE_ID
QC_RSLT_MSTI3 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnQC_SPEC_ID
QC_RSLT_MSTI4 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnFORMULALINE_ID
Columns
Name Datatype Length Mandatory Comments
QCASSY_TYP_ID NUMBER (15) Yes Surrogate key id used to access qc_assy_typ to get the assay type
QC_RESULT_ID NUMBER (10) Yes Surrogate key for the result.
QC_SPEC_ID NUMBER (10)
Surrogate key for the specification to which the result is compared.
ORGN_CODE VARCHAR2 (4) Yes Organization code.
SAMPLE_ID NUMBER (10) Yes Surrogate key for the sample which was tested to yield this result.
RESULT_DATE DATE

Date on which the result was acquired.
ASSAY_CODE VARCHAR2 (16) Yes Assay for which the sample was tested.
TEXT_RESULT VARCHAR2 (16)
Result for assay_types 0 and 2.
NUM_RESULT NUMBER

Result for assay_type 1.
QCUNIT_CODE VARCHAR2 (4) Yes Unit of measure for the result.
ACCEPT_ANYWAY NUMBER (5) Yes Indicates whether the results have been accepted. 0=Not accepted, 1=Accepted.
FINAL_MARK NUMBER (5) Yes Indicates whether the results are considered final and will print on certificates of analysis. 0=Not final, 1=Final.
TEST_PROVIDER_CODE VARCHAR2 (8)
Not currently used.
ITEM_ID NUMBER (10) Yes Surrogate key for the item for which results are recorded.
LOT_ID NUMBER (10)
Surrogate key for the lot/sublot for which results are recorded.
WHSE_CODE VARCHAR2 (4)
Warehouse from which the item was taken.
LOCATION VARCHAR2 (16)
Location from which the item was taken.
FORMULA_ID NUMBER (10)
Surrogate key for the formula for which results are recorded.
FORMULALINE_ID NUMBER (10)
Surrogate key for the formula line for which results are recorded.
ROUTING_ID NUMBER (10)
Surrogate key for the routing for which results are recorded.
ROUTINGSTEP_ID NUMBER (10)
Surrogate key for the routing step for which results are recorded.
OPRN_ID NUMBER (10)
Surrogate key for the operation for which results are recorded.
CUST_ID NUMBER (15)
Surrogate key for the customer for which results are recorded.
VENDOR_ID NUMBER (10)
Surrogate key for the vendor for which results are recorded.
BATCH_ID NUMBER (10)
Surrogate key for the batch for which results are recorded.
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
CREATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
ROUTINGSTEP_NO NUMBER (5)
The routing step number from Formula routing detail
ASSAY_TESTER VARCHAR2 (30)
Assay tester
WF_RESPONSE VARCHAR2 (240)
Workflow response
ASSAY_RETEST NUMBER (5)
Assay Retest Flag
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
OPM_CUST_ID NUMBER (10)
Used by OM users only. Stores customer id to op_cust_mst (OPM customer table) for historical purposes.
CHARGE NUMBER

Charge associated with sample.
ORDER_HEADER_ID NUMBER

Order ID used for order-specific customer results. FK = OE_ORDER_HEADERS.ALL.header_id
ORDER_LINE VARCHAR2 (16)
Concatenated order line number used for order-line-specific data. Corresponds to what user sees on Orders forms.
ORDER_LINE_ID NUMBER

Order line ID used for order-line-specific customer results. FK =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 results. Should help performance.
SHIP_TO_SITE_ID NUMBER

Ship-to ID/cust-site used for order-specific customer results. FK = HZ_CUST_ACCT_SITES_ALL.cust_acct_site_id
MIGRATION_STATUS VARCHAR2 (4)
Record migration status
OLD_QC_SPEC_ID NUMBER

This column is used for migration
Query Text

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


SELECT QCASSY_TYP_ID
,      QC_RESULT_ID
,      QC_SPEC_ID
,      ORGN_CODE
,      SAMPLE_ID
,      RESULT_DATE
,      ASSAY_CODE
,      TEXT_RESULT
,      NUM_RESULT
,      QCUNIT_CODE
,      ACCEPT_ANYWAY
,      FINAL_MARK
,      TEST_PROVIDER_CODE
,      ITEM_ID
,      LOT_ID
,      WHSE_CODE
,      LOCATION
,      FORMULA_ID
,      FORMULALINE_ID
,      ROUTING_ID
,      ROUTINGSTEP_ID
,      OPRN_ID
,      CUST_ID
,      VENDOR_ID
,      BATCH_ID
,      DELETE_MARK
,      TEXT_CODE
,      TRANS_CNT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      ROUTINGSTEP_NO
,      ASSAY_TESTER
,      WF_RESPONSE
,      ASSAY_RETEST
,      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
,      OPM_CUST_ID
,      CHARGE
,      ORDER_HEADER_ID
,      ORDER_LINE
,      ORDER_LINE_ID
,      ORDER_ORG_ID
,      QC_REC_TYPE
,      SHIP_TO_SITE_ID
,      MIGRATION_STATUS
,      OLD_QC_SPEC_ID
FROM GMD.QC_RSLT_MST;

Dependencies

[top of page]

GMD.QC_RSLT_MST does not reference any database object

GMD.QC_RSLT_MST is referenced by following:

SchemaGMD
ViewQC_RSLT_MST#