[Home] [Help] [Dependency Information]
Object Name: | GMD_QC_E_SPEC_TESTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GMD.GMD_QC_E_SPEC_TESTS_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SPEC_ID | NUMBER | Yes | ||
TEST_ID | NUMBER | Yes | ||
TEST_METHOD_ID | NUMBER | Yes | ||
SEQ | NUMBER | Yes | ||
TEST_METHOD_CODE | VARCHAR2 | (80) | Yes | |
TEST_REPLICATE | NUMBER | Yes | ||
TEST_QTY | NUMBER | |||
TEST_QTY_UOM | VARCHAR2 | (3) | ||
SPEC_MIN_VALUE | VARCHAR2 | (40) | ||
SPEC_TARGET_VALUE | VARCHAR2 | (40) | ||
SPEC_MAX_VALUE | VARCHAR2 | (40) | ||
MIN_VALUE_NUM | NUMBER | |||
TARGET_VALUE_NUM | NUMBER | |||
MAX_VALUE_NUM | NUMBER | |||
MIN_VALUE_CHAR | VARCHAR2 | (16) | ||
TARGET_VALUE_CHAR | VARCHAR2 | (16) | ||
MAX_VALUE_CHAR | VARCHAR2 | (16) | ||
BELOW_SPEC_MIN | NUMBER | |||
ABOVE_SPEC_MIN | NUMBER | |||
BELOW_SPEC_MAX | NUMBER | |||
ABOVE_SPEC_MAX | NUMBER | |||
BELOW_MIN_ACTION_CODE | VARCHAR2 | (32) | ||
ABOVE_MIN_ACTION_CODE | VARCHAR2 | (32) | ||
BELOW_MAX_ACTION_CODE | VARCHAR2 | (32) | ||
ABOVE_MAX_ACTION_CODE | VARCHAR2 | (32) | ||
OPTIONAL_IND | VARCHAR2 | (80) | ||
DISPLAY_PRECISION | NUMBER | (2) | ||
REPORT_PRECISION | NUMBER | (2) | ||
OUT_OF_SPEC_ACTION | VARCHAR2 | (32) | ||
TEST_PRIORITY | VARCHAR2 | (80) | Yes | |
RETEST_LOT_EXPIRY_IND | VARCHAR2 | (80) | ||
EXP_ERROR_TYPE | VARCHAR2 | (80) | ||
PRINT_SPEC_IND | VARCHAR2 | (80) | ||
PRINT_RESULT_IND | VARCHAR2 | (80) | ||
TEST_DISPLAY | VARCHAR2 | (240) | ||
TEXT_CODE | NUMBER | (10) | ||
OUT_OF_SPEC_ACTION_DESC | VARCHAR2 | (80) | ||
OUT_OF_SPEC_ACTION_INTERVAL | NUMBER | |||
EXPRESSION | VARCHAR2 | (4000) | ||
TEST_CODE | VARCHAR2 | (80) | Yes | |
TEST_DESC | VARCHAR2 | (240) | Yes | |
TEST_UNIT | VARCHAR2 | (25) | ||
TEST_TYPE | VARCHAR2 | (1) | Yes | |
TEST_TYPE_DESC | VARCHAR2 | (80) | Yes | |
TEST_CLASS | VARCHAR2 | (8) | ||
TEST_MIN_VALUE | NUMBER | |||
TEST_MAX_VALUE | NUMBER | |||
SPEC_TARGET_MEANING | VARCHAR2 | (4000) | ||
SPEC_MIN_MEANING | VARCHAR2 | (4000) | ||
SPEC_MAX_MEANING | VARCHAR2 | (4000) | ||
TEST_MIN_MEANING | VARCHAR2 | (4000) | ||
TEST_MAX_MEANING | VARCHAR2 | (4000) | ||
FROM_BASE_IND | VARCHAR2 | (1) | ||
EXCLUDE_IND | VARCHAR2 | (1) | ||
MODIFIED_IND | VARCHAR2 | (1) | ||
CALC_UOM_CONV_IND | VARCHAR2 | (1) | ||
TO_QTY_UOM | VARCHAR2 | (3) |
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_QTY_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_BASE_IND
, EXCLUDE_IND
, MODIFIED_IND
, CALC_UOM_CONV_IND
, TO_QTY_UOM
FROM APPS.GMD_QC_E_SPEC_TESTS_V;
APPS.GMD_QC_E_SPEC_TESTS_V is not referenced by any database object
|
|
|