[Home] [Help] [Dependency Information]
Object Name: | GMD_SPEC_TESTS_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GMD.GMD_SPEC_TESTS_VL |
Subobject Name: | |
Status: | VALID |
MultiLingual view (a language resolved view of the data.)
OPM Specification tests View
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
SPEC_ID | NUMBER | Yes | Specification Identification | |
TEST_ID | NUMBER | Yes | Test Identification | |
TEST_METHOD_ID | NUMBER | Yes | Test Method Identification | |
SEQ | NUMBER | Yes | Test sequence | |
TEST_QTY | NUMBER | Qty of sample required to perform test. | ||
TEST_QTY_UOM | VARCHAR2 | (3) | test quantity uom | |
MIN_VALUE_NUM | NUMBER | Min target value for numeric range test type | ||
TARGET_VALUE_NUM | NUMBER | Test target value. | ||
MAX_VALUE_NUM | NUMBER | Max target value for numeric range test type | ||
MIN_VALUE_CHAR | VARCHAR2 | (16) | Min target value for text range test type | |
TARGET_VALUE_CHAR | VARCHAR2 | (16) | Target value for Test when test type is LOV or text range | |
MAX_VALUE_CHAR | VARCHAR2 | (16) | Max target value for text range test type | |
TEST_REPLICATE | NUMBER | Yes | The number of times a test is repeated for the same sample instance. Defaults to 1 | |
CHECK_RESULT_INTERVAL | NUMBER | Frequency result values are checked for out-of-spec condition. | ||
PRINT_ON_COA_IND | VARCHAR2 | (1) | Print on Cerificate of analysis | |
USE_TO_CONTROL_STEP | VARCHAR2 | (1) | Use to control step | |
OUT_OF_SPEC_ACTION | VARCHAR2 | (32) | Out of Specification action | |
EXP_ERROR_TYPE | VARCHAR2 | (1) | NUM = Number PCT = Percent | |
BELOW_SPEC_MIN | NUMBER | Below Specification Minimum | ||
ABOVE_SPEC_MIN | NUMBER | above Specification Minimum | ||
BELOW_SPEC_MAX | NUMBER | Below Specification Maximum | ||
ABOVE_SPEC_MAX | NUMBER | Above Specification maximum | ||
BELOW_MIN_ACTION_CODE | VARCHAR2 | (32) | Action code for results In the test error region spec min - test error | |
ABOVE_MIN_ACTION_CODE | VARCHAR2 | (32) | Action code for results In the test error region spec min + test error | |
OPTIONAL_IND | VARCHAR2 | (1) | Indicates if a test is optional.Y = YesNull = No | |
DISPLAY_PRECISION | NUMBER | (2) | Decimal precision of saved value | |
REPORT_PRECISION | NUMBER | (2) | Decimal precision used to display value | |
TEST_PRIORITY | VARCHAR2 | (2) | Yes | Test priority H = HighN = Normal L = Low |
RETEST_LOT_EXPIRY_IND | VARCHAR2 | (1) | Indicates spec is used to retest for lot expiration, etc.Y = Yes | |
PRINT_SPEC_IND | VARCHAR2 | (1) | Print Specification indicator | |
PRINT_RESULT_IND | VARCHAR2 | (1) | Print Result indicator | |
BELOW_MAX_ACTION_CODE | VARCHAR2 | (32) | Action code for results In the test error region spec max - test error | |
ABOVE_MAX_ACTION_CODE | VARCHAR2 | (32) | Action code for results In the test error region spec max + test error | |
TEST_DISPLAY | VARCHAR2 | (240) | ||
TEXT_CODE | NUMBER | (10) | Edit text code | |
VIABILITY_DURATION | NUMBER | Total Sample Viability for Test | ||
DAYS | NUMBER | (10) | Sample viability for the test in number of days | |
HOURS | NUMBER | (10) | Sample viability for the test in number of hours | |
MINUTES | NUMBER | (10) | Sample viability for the test in number of minutes | |
SECONDS | NUMBER | (10) | Sample viability for the test in number of seconds | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure ID | |
ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive Flexfield column | |
ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive Flexfield column | |
ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive Flexfield column | |
ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive Flexfield column | |
ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive Flexfield column | |
ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive Flexfield column | |
ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive Flexfield column | |
ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive Flexfield column | |
ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive Flexfield column | |
ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive Flexfield column | |
ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive Flexfield column | |
ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive Flexfield column | |
ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive Flexfield column | |
ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive Flexfield column | |
ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive Flexfield column | |
ATTRIBUTE16 | VARCHAR2 | (240) | Descriptive Flexfield column | |
ATTRIBUTE17 | VARCHAR2 | (240) | Descriptive Flexfield column | |
ATTRIBUTE18 | VARCHAR2 | (240) | Descriptive Flexfield column | |
ATTRIBUTE19 | VARCHAR2 | (240) | Descriptive Flexfield column | |
ATTRIBUTE20 | VARCHAR2 | (240) | Descriptive Flexfield column | |
ATTRIBUTE21 | VARCHAR2 | (240) | Descriptive Flexfield column | |
ATTRIBUTE22 | VARCHAR2 | (240) | Descriptive Flexfield column | |
ATTRIBUTE23 | VARCHAR2 | (240) | Descriptive Flexfield column | |
ATTRIBUTE24 | VARCHAR2 | (240) | Descriptive Flexfield column | |
ATTRIBUTE25 | VARCHAR2 | (240) | Descriptive Flexfield column | |
ATTRIBUTE26 | VARCHAR2 | (240) | Descriptive Flexfield column | |
ATTRIBUTE27 | VARCHAR2 | (240) | Descriptive Flexfield column | |
ATTRIBUTE28 | VARCHAR2 | (240) | Descriptive Flexfield column | |
ATTRIBUTE29 | VARCHAR2 | (240) | Descriptive Flexfield column | |
ATTRIBUTE30 | VARCHAR2 | (240) | Descriptive Flexfield column | |
CREATION_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
FROM_BASE_IND | VARCHAR2 | (1) | Indicator for test from base spec | |
EXCLUDE_IND | VARCHAR2 | (1) | Indicator if the test is excluded from base spec | |
MODIFIED_IND | VARCHAR2 | (1) | Indicator if the test is modified from base spec | |
CALC_UOM_CONV_IND | VARCHAR2 | (1) | Indicates whether to calculate UOM Conversion based on the result of the test. | |
TO_QTY_UOM | VARCHAR2 | (3) | TO QTY UOM |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, SPEC_ID
, TEST_ID
, TEST_METHOD_ID
, SEQ
, TEST_QTY
, TEST_QTY_UOM
, MIN_VALUE_NUM
, TARGET_VALUE_NUM
, MAX_VALUE_NUM
, MIN_VALUE_CHAR
, TARGET_VALUE_CHAR
, MAX_VALUE_CHAR
, TEST_REPLICATE
, CHECK_RESULT_INTERVAL
, PRINT_ON_COA_IND
, USE_TO_CONTROL_STEP
, OUT_OF_SPEC_ACTION
, EXP_ERROR_TYPE
, BELOW_SPEC_MIN
, ABOVE_SPEC_MIN
, BELOW_SPEC_MAX
, ABOVE_SPEC_MAX
, BELOW_MIN_ACTION_CODE
, ABOVE_MIN_ACTION_CODE
, OPTIONAL_IND
, DISPLAY_PRECISION
, REPORT_PRECISION
, TEST_PRIORITY
, RETEST_LOT_EXPIRY_IND
, PRINT_SPEC_IND
, PRINT_RESULT_IND
, BELOW_MAX_ACTION_CODE
, ABOVE_MAX_ACTION_CODE
, TEST_DISPLAY
, TEXT_CODE
, VIABILITY_DURATION
, DAYS
, HOURS
, MINUTES
, SECONDS
, ATTRIBUTE_CATEGORY
, 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
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, FROM_BASE_IND
, EXCLUDE_IND
, MODIFIED_IND
, CALC_UOM_CONV_IND
, TO_QTY_UOM
FROM APPS.GMD_SPEC_TESTS_VL;
|
|
|