[Home] [Help] [Dependency Information]
Object Name: | PMITS_QC_SPEC_TESTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PMI.PMITS_QC_SPEC_TESTS_V |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SPEC_ID | NUMBER | Unique Identifier for Spec | ||
TEST_ID | NUMBER | Unique Identifier for Test | ||
TEST_METHOD_ID | NUMBER | Unique Identifier for Test method | ||
SEQ | NUMBER | Test Sequence | ||
TEST_METHOD_CODE | CHAR | (3) | Test Method Code | |
TEST_REPLICATE | NUMBER | Replicate | ||
TEST_QTY | NUMBER | Test Qty | ||
TEST_UOM | CHAR | (3) | Test UOM | |
SPEC_MIN_VALUE | CHAR | (3) | Spec Min. This includes both Spec Min Char and Num | |
SPEC_TARGET_VALUE | CHAR | (3) | Spec Target.This includes both Spec Target Char and Num | |
SPEC_MAX_VALUE | CHAR | (3) | Spec Max. This includes both Spec Max Char and Num | |
MIN_VALUE_NUM | NUMBER | Spec Numeric Min | ||
TARGET_VALUE_NUM | NUMBER | Spec Target Numeric | ||
MAX_VALUE_NUM | NUMBER | Spec Max Numeric | ||
MIN_VALUE_CHAR | CHAR | (3) | Spec Min Char | |
TARGET_VALUE_CHAR | CHAR | (3) | Spec Target Char | |
MAX_VALUE_CHAR | CHAR | (3) | Spec Max Char | |
BELOW_SPEC_MIN | NUMBER | Below Spec Min | ||
ABOVE_SPEC_MIN | NUMBER | Above Spec Min | ||
BELOW_SPEC_MAX | NUMBER | Below Spec Max | ||
ABOVE_SPEC_MAX | NUMBER | Above Spec Max | ||
BELOW_MIN_ACTION_CODE | CHAR | (3) | Below Spec Min Action Code | |
ABOVE_MIN_ACTION_CODE | CHAR | (3) | Above Spec Min Action Code | |
BELOW_MAX_ACTION_CODE | CHAR | (3) | Below Spec Max Action Code | |
ABOVE_MAX_ACTION_CODE | CHAR | (3) | Above Spec Max Action Code | |
OPTIONAL_IND | CHAR | (3) | Optional Test Indicator | |
DISPLAY_PRECISION | NUMBER | Numeric Result Display Precision | ||
REPORT_PRECISION | NUMBER | Numeric Result Reporting Precision | ||
OUT_OF_SPEC_ACTION | CHAR | (3) | Out of spec Action | |
TEST_PRIORITY | CHAR | (3) | Test Priority | |
RETEST_LOT_EXPIRY_IND | CHAR | (3) | Lot Retest / Expiry Indicator | |
EXP_ERROR_TYPE | CHAR | (3) | Experimental Error Type | |
PRINT_SPEC_IND | CHAR | (3) | Print Spec Indicator | |
PRINT_RESULT_IND | CHAR | (3) | Print Result Indicator | |
TEST_DISPLAY | CHAR | (3) | Test Display | |
TEXT_CODE | NUMBER | Test Code | ||
OUT_OF_SPEC_ACTION_DESC | CHAR | (3) | Out of spec Action Description | |
OUT_OF_SPEC_ACTION_INTERVAL | NUMBER | Out of Spec Action Interval | ||
EXPRESSION | CHAR | (3) | Expression | |
TEST_CODE | CHAR | (3) | Test Code | |
TEST_DESC | CHAR | (3) | Test Description | |
TEST_UNIT | CHAR | (3) | QC Unit Code | |
TEST_TYPE | CHAR | (3) | Test Type | |
TEST_TYPE_DESC | CHAR | (3) | Test Type meaning resolved using GEM LOOKUPS | |
TEST_CLASS | CHAR | (3) | Test Class | |
TEST_MIN_VALUE | NUMBER | Min Value allowed as per test definition | ||
TEST_MAX_VALUE | NUMBER | Max Value allowed as per test definition | ||
SPEC_TARGET_MEANING | CHAR | (3) | Target Meaning | |
SPEC_MIN_MEANING | CHAR | (3) | Spec Min Meaning | |
SPEC_MAX_MEANING | CHAR | (3) | Spec Max Meaning | |
TEST_MIN_MEANING | CHAR | (3) | Test Min Meaning | |
TEST_MAX_MEANING | CHAR | (3) | Test Max Meaning |
Cut, paste (and edit) the following text to query this object:
SELECT SPEC_ID
, TEST_ID
, TEST_METHOD_ID
, SEQ
, TEST_METHOD_CODE
, TEST_REPLICATE
, TEST_QTY
, TEST_UOM
, SPEC_MIN_VALUE
, SPEC_TARGET_VALUE
, SPEC_MAX_VALUE
, MIN_VALUE_NUM
, TARGET_VALUE_NUM
, MAX_VALUE_NUM
, MIN_VALUE_CHAR
, TARGET_VALUE_CHAR
, MAX_VALUE_CHAR
, BELOW_SPEC_MIN
, ABOVE_SPEC_MIN
, BELOW_SPEC_MAX
, ABOVE_SPEC_MAX
, BELOW_MIN_ACTION_CODE
, ABOVE_MIN_ACTION_CODE
, BELOW_MAX_ACTION_CODE
, ABOVE_MAX_ACTION_CODE
, OPTIONAL_IND
, DISPLAY_PRECISION
, REPORT_PRECISION
, OUT_OF_SPEC_ACTION
, TEST_PRIORITY
, RETEST_LOT_EXPIRY_IND
, EXP_ERROR_TYPE
, PRINT_SPEC_IND
, PRINT_RESULT_IND
, TEST_DISPLAY
, TEXT_CODE
, OUT_OF_SPEC_ACTION_DESC
, OUT_OF_SPEC_ACTION_INTERVAL
, EXPRESSION
, TEST_CODE
, TEST_DESC
, TEST_UNIT
, TEST_TYPE
, TEST_TYPE_DESC
, TEST_CLASS
, TEST_MIN_VALUE
, TEST_MAX_VALUE
, SPEC_TARGET_MEANING
, SPEC_MIN_MEANING
, SPEC_MAX_MEANING
, TEST_MIN_MEANING
, TEST_MAX_MEANING
FROM APPS.PMITS_QC_SPEC_TESTS_V;
APPS.PMITS_QC_SPEC_TESTS_V is not referenced by any database object
|
|
|