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_SPEC_MST

Object Details

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

QC specification master. Contains customer, vendor, item/location, and production specifications for desired (nominal) assay results.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QC_SPEC_MST_PK	NORMAL	UNIQUE	APPS_TS_ARCHIVE	QC_SPEC_ID
QC_SPEC_MSTI1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	ORGN_CODE CUST_ID VENDOR_ID ITEM_ID FROM_DATE TO_DATE
QC_SPEC_MSTI2	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	ORGN_CODE ITEM_ID LOT_ID WHSE_CODE LOCATION ASSAY_CODE FROM_DATE TO_DATE
QC_SPEC_MSTI3	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	ORGN_CODE BATCH_ID FORMULA_ID FORMULALINE_ID ROUTING_ID ROUTINGSTEP_ID OPRN_ID ITEM_ID FROM_DATE TO_DATE
QC_SPEC_MSTI4	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	FORMULALINE_ID
QC_SPEC_MST_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	QC_REC_TYPE ORGN_CODE CUST_ID ORDER_ORG_ID SHIP_TO_SITE_ID ORDER_HEADER_ID ITEM_ID FROM_DATE TO_DATE
QC_SPEC_MST_N2	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	QC_REC_TYPE ORGN_CODE ITEM_ID LOT_ID WHSE_CODE LOCATION FROM_DATE TO_DATE
QC_SPEC_MST_N3	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	QC_REC_TYPE ORGN_CODE BATCH_ID FORMULA_ID FORMULALINE_ID ROUTING_ID ROUTINGSTEP_ID OPRN_ID ITEM_ID FROM_DATE TO_DATE
QC_SPEC_MST_N4	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	SPEC_HDR_ID
QC_SPEC_MST_N5	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	QC_REC_TYPE ORGN_CODE VENDOR_ID ITEM_ID FROM_DATE TO_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
QC_SPEC_ID	NUMBER	(10)	Yes	Surrogate key for the specification.
QCASSY_TYP_ID	NUMBER	(15)	Yes	Surrogate key id used to access qc_assy_typ to get the assay type
ORGN_CODE	VARCHAR2	(4)		Organization for which the specs are entered.
ITEM_ID	NUMBER	(10)	Yes	Surrogate key for the item for which specs are recorded.
LOT_ID	NUMBER	(10)		Surrogate key for the lot/sublot for which specs are recorded.
WHSE_CODE	VARCHAR2	(4)		Warehouse for which specs are recorded.
LOCATION	VARCHAR2	(16)		Location for which specs are recorded.
FORMULA_ID	NUMBER	(10)		Surrogate key to formula for which specs are recorded.
FORMULALINE_ID	NUMBER	(10)		Surrogate key to formula line for which specs are recorded.
ROUTING_ID	NUMBER	(10)		Surrogate key to routing for which specs are recorded.
ROUTINGSTEP_ID	NUMBER	(10)		Surrogate key to routing step for which specs are recorded.
OPRN_ID	NUMBER	(10)		Surrogate key to operation for which specs are recorded.
DOC_TYPE	VARCHAR2	(4)		Not currently used.
DOC_ID	NUMBER	(10)		Not currently used.
DOCLINE_ID	NUMBER	(10)		Not currently used.
CUST_ID	NUMBER	(15)		Surrogate key to customer for which specs are recorded.
CUST_SPECIFICATION	NUMBER	(5)		Not currently used.
CUST_CERTIFICATION	NUMBER	(5)		Not currently used.
VENDOR_ID	NUMBER	(10)		Surrogate key for vendor for which specs are recorded.
VENDOR_SPECIFICATION	NUMBER	(5)		Not currently used.
VENDOR_CERTIFICATION	NUMBER	(5)		Not currently used.
BATCH_ID	NUMBER	(10)		Surrogate key for batch for which specs are recorded.
ASSAY_CODE	VARCHAR2	(16)	Yes	Assay for which specs are recorded.
TEXT_SPEC	VARCHAR2	(16)		Specification for assay_type 0 and 2.
TARGET_SPEC	NUMBER			Specification for assay_type 1.
MIN_SPEC	NUMBER			Lower bound for result within spec for assay type 1.
MAX_SPEC	NUMBER			Upper bound for result within spec for aassay_type 1.
QCUNIT_CODE	VARCHAR2	(4)	Yes	Unit of measure code associated with this assay.
FROM_DATE	DATE		Yes	Earliest effective date for the specification.
TO_DATE	DATE		Yes	Latest effective date for the specification.
OUTACTION_CODE	VARCHAR2	(4)		Action to be performed upon failing to meet specification.
OUTACTION_INTERVAL	NUMBER			Interval (decimal days) between failing result and performance of out of spec action.
PREFERENCE	NUMBER	(5)	Yes	Preference among specs.
PRINT_COA_SHIPPED	NUMBER	(5)		0=Do not print certificate of analysis when material is shipped, 1=Print certificate of analysis when material is shipped.
PRINT_COA_INVOICED	NUMBER	(5)		0=Do not print certificate of analysis when material is invoiced, 1=Print certificate of analysis when material is invoiced.
VENDOR_COA_REQUIRED	NUMBER	(5)		0=Certificate of analysis from vendor is not required, 1=Certificate of analysis from vendor is required.
TEST_OPRN_ID	NUMBER	(10)		Not currently used.
TEST_OPRN_LINE_ID	NUMBER	(10)		Not currently used.
TEST_PROVIDER_CODE	VARCHAR2	(8)		Not currently used.
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)		Routingstep_no from fm_rout_dtl
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			The charge number for which this specification is effective, relating to the routing step entered.
OUTSIDE_SPEC_MIN	NUMBER			Number or percent representing experimental error fuzzy zone below spec min
INSIDE_SPEC_MIN	NUMBER			Number or percent representing experimental error fuzzy zone above spec min
INSIDE_SPEC_MAX	NUMBER			Number or percent representing experimental error fuzzy zone below spec max'
OUTSIDE_SPEC_MAX	NUMBER			Number or percent representing experimental error fuzzy zone above spec max
ERROR_VAL_TYPE	VARCHAR2	(30)		NUM or PCT (from gem_lookups). Defines values in experimental error columns.
OUTSIDE_MIN_ACTION_CODE	VARCHAR2	(4)		Action code (from qc_actn_mst) to display when result falls below spec min
INSIDE_MIN_ACTION_CODE	VARCHAR2	(4)		Action code (from qc_actn_mst) to display when result falls above spec min
INSIDE_MAX_ACTION_CODE	VARCHAR2	(4)		Action code (from qc_actn_mst) to display when result falls below spec max'
OUTSIDE_MAX_ACTION_CODE	VARCHAR2	(4)		Action code (from qc_actn_mst) to display when result falls above spec max
MIN_CHAR	VARCHAR2	(16)		Minimum value for an assay of type text range
MAX_CHAR	VARCHAR2	(16)		Maximum value for an assay of type text range
ORDER_HEADER_ID	NUMBER			Order ID used for order-specific customer specs. FK =OE_ORDER_HEADERS_ALL.header_id
ORDER_LINE_NO	NUMBER			Simple, numeric order line number used for order-line-specific customer specs. FK = OE_ORDER_LINES_ALL.line_no
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 specification. Should help performance.
SHIP_TO_SITE_ID	NUMBER			Indicator for item/loc vs customer vs supplier vs production specification. Should help performance
SPEC_HDR_ID	NUMBER			ID which relates all assay lines for one SPEC together. Needed before we create header and detail tables for spec matching.
MIGRATION_STATUS	VARCHAR2	(4)		Record migration status
OLD_FROM_DATE	DATE			This column is used for migration
OLD_TO_DATE	DATE			This column is used for migration

Query Text

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


SELECT QC_SPEC_ID
,      QCASSY_TYP_ID
,      ORGN_CODE
,      ITEM_ID
,      LOT_ID
,      WHSE_CODE
,      LOCATION
,      FORMULA_ID
,      FORMULALINE_ID
,      ROUTING_ID
,      ROUTINGSTEP_ID
,      OPRN_ID
,      DOC_TYPE
,      DOC_ID
,      DOCLINE_ID
,      CUST_ID
,      CUST_SPECIFICATION
,      CUST_CERTIFICATION
,      VENDOR_ID
,      VENDOR_SPECIFICATION
,      VENDOR_CERTIFICATION
,      BATCH_ID
,      ASSAY_CODE
,      TEXT_SPEC
,      TARGET_SPEC
,      MIN_SPEC
,      MAX_SPEC
,      QCUNIT_CODE
,      FROM_DATE
,      TO_DATE
,      OUTACTION_CODE
,      OUTACTION_INTERVAL
,      PREFERENCE
,      PRINT_COA_SHIPPED
,      PRINT_COA_INVOICED
,      VENDOR_COA_REQUIRED
,      TEST_OPRN_ID
,      TEST_OPRN_LINE_ID
,      TEST_PROVIDER_CODE
,      DELETE_MARK
,      TEXT_CODE
,      TRANS_CNT
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      ROUTINGSTEP_NO
,      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
,      OUTSIDE_SPEC_MIN
,      INSIDE_SPEC_MIN
,      INSIDE_SPEC_MAX
,      OUTSIDE_SPEC_MAX
,      ERROR_VAL_TYPE
,      OUTSIDE_MIN_ACTION_CODE
,      INSIDE_MIN_ACTION_CODE
,      INSIDE_MAX_ACTION_CODE
,      OUTSIDE_MAX_ACTION_CODE
,      MIN_CHAR
,      MAX_CHAR
,      ORDER_HEADER_ID
,      ORDER_LINE_NO
,      ORDER_ORG_ID
,      QC_REC_TYPE
,      SHIP_TO_SITE_ID
,      SPEC_HDR_ID
,      MIGRATION_STATUS
,      OLD_FROM_DATE
,      OLD_TO_DATE
FROM GMD.QC_SPEC_MST;

Dependencies

[top of page]

GMD.QC_SPEC_MST does not reference any database object

GMD.QC_SPEC_MST is referenced by following:

GMD: QC_SPEC_MST#