[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GMD_SPEC_TESTS_B# |
|---|---|
| Object Type: | VIEW |
| Owner: | GMD |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SPEC_ID | NUMBER | Yes | ||
| TEST_ID | NUMBER | Yes | ||
| TEST_METHOD_ID | NUMBER | Yes | ||
| SEQ | NUMBER | Yes | ||
| TEST_QTY | NUMBER | |||
| TEST_UOM | VARCHAR2 | (4) | ||
| 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) | ||
| TEST_REPLICATE | NUMBER | Yes | ||
| CHECK_RESULT_INTERVAL | NUMBER | |||
| PRINT_ON_COA_IND | VARCHAR2 | (1) | ||
| USE_TO_CONTROL_STEP | VARCHAR2 | (1) | ||
| OUT_OF_SPEC_ACTION | VARCHAR2 | (32) | ||
| EXP_ERROR_TYPE | VARCHAR2 | (1) | ||
| 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 | (1) | ||
| DISPLAY_PRECISION | NUMBER | (2) | ||
| REPORT_PRECISION | NUMBER | (2) | ||
| TEST_PRIORITY | VARCHAR2 | (2) | Yes | |
| RETEST_LOT_EXPIRY_IND | VARCHAR2 | (1) | ||
| PRINT_SPEC_IND | VARCHAR2 | (1) | ||
| PRINT_RESULT_IND | VARCHAR2 | (1) | ||
| TEXT_CODE | NUMBER | (10) | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| ATTRIBUTE1 | VARCHAR2 | (240) | ||
| ATTRIBUTE2 | VARCHAR2 | (240) | ||
| ATTRIBUTE3 | VARCHAR2 | (240) | ||
| ATTRIBUTE4 | VARCHAR2 | (240) | ||
| ATTRIBUTE5 | VARCHAR2 | (240) | ||
| ATTRIBUTE6 | VARCHAR2 | (240) | ||
| ATTRIBUTE7 | VARCHAR2 | (240) | ||
| ATTRIBUTE8 | VARCHAR2 | (240) | ||
| ATTRIBUTE9 | VARCHAR2 | (240) | ||
| ATTRIBUTE10 | VARCHAR2 | (240) | ||
| ATTRIBUTE11 | VARCHAR2 | (240) | ||
| ATTRIBUTE12 | VARCHAR2 | (240) | ||
| ATTRIBUTE13 | VARCHAR2 | (240) | ||
| ATTRIBUTE14 | VARCHAR2 | (240) | ||
| ATTRIBUTE15 | VARCHAR2 | (240) | ||
| ATTRIBUTE16 | VARCHAR2 | (240) | ||
| ATTRIBUTE17 | VARCHAR2 | (240) | ||
| ATTRIBUTE18 | VARCHAR2 | (240) | ||
| ATTRIBUTE19 | VARCHAR2 | (240) | ||
| ATTRIBUTE20 | VARCHAR2 | (240) | ||
| ATTRIBUTE21 | VARCHAR2 | (240) | ||
| ATTRIBUTE22 | VARCHAR2 | (240) | ||
| ATTRIBUTE23 | VARCHAR2 | (240) | ||
| ATTRIBUTE24 | VARCHAR2 | (240) | ||
| ATTRIBUTE25 | VARCHAR2 | (240) | ||
| ATTRIBUTE26 | VARCHAR2 | (240) | ||
| ATTRIBUTE27 | VARCHAR2 | (240) | ||
| ATTRIBUTE28 | VARCHAR2 | (240) | ||
| ATTRIBUTE29 | VARCHAR2 | (240) | ||
| ATTRIBUTE30 | VARCHAR2 | (240) | ||
| CREATION_DATE | DATE | Yes | ||
| CREATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| DAYS | NUMBER | (10) | ||
| HOURS | NUMBER | (10) | ||
| MINUTES | NUMBER | (10) | ||
| SECONDS | NUMBER | (10) | ||
| VIABILITY_DURATION | NUMBER | |||
| FROM_BASE_IND | VARCHAR2 | (1) | ||
| EXCLUDE_IND | VARCHAR2 | (1) | ||
| MODIFIED_IND | VARCHAR2 | (1) | ||
| CALC_UOM_CONV_IND | VARCHAR2 | (1) | ||
| TO_UOM | VARCHAR2 | (4) | ||
| TEST_QTY_UOM | VARCHAR2 | (3) | ||
| 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_QTY
, TEST_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
, BELOW_MAX_ACTION_CODE
, ABOVE_MAX_ACTION_CODE
, OPTIONAL_IND
, DISPLAY_PRECISION
, REPORT_PRECISION
, TEST_PRIORITY
, RETEST_LOT_EXPIRY_IND
, PRINT_SPEC_IND
, PRINT_RESULT_IND
, TEXT_CODE
, 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
, DAYS
, HOURS
, MINUTES
, SECONDS
, VIABILITY_DURATION
, FROM_BASE_IND
, EXCLUDE_IND
, MODIFIED_IND
, CALC_UOM_CONV_IND
, TO_UOM
, TEST_QTY_UOM
, TO_QTY_UOM
FROM GMD.GMD_SPEC_TESTS_B#;
GMD
GMD_SPEC_TESTS_B
APPS
GMD_SPEC_TESTS_B
|
|
|
|