[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GMD_SPEC_TESTS_B |
|---|---|
| Object Type: | TABLE |
| Owner: | GMD |
| FND Design Data: |  GMD.GMD_SPEC_TESTS_B
|
| Subobject Name: | |
| Status: | VALID |
OPM Specification tests
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| GMD_SPEC_TESTS_B_PK | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 SPEC_ID
TEST_ID
|
| GMD_SPEC_TESTS_B_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
SPEC_ID
SEQ
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SPEC_ID | NUMBER | Yes | Specification Identification | |
| TEST_ID | NUMBER | Yes | Test Identification | |
| TEST_METHOD_ID | NUMBER | Yes | Test Method Identification | |
| SEQ | NUMBER | Yes | Test Step | |
| TEST_QTY | NUMBER | Qty of sample required to perform test. | ||
| TEST_UOM | VARCHAR2 | (4) | UOM the test sample qty is recorded. | |
| 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 | |
| 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 | |
| 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 | |
| TEXT_CODE | NUMBER | (10) | Edit text code | |
| 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 | |
| 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. | |
| VIABILITY_DURATION | NUMBER | Total Sample Viability for the Test. | ||
| 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_UOM | VARCHAR2 | (4) | UOM to which the conversion is created. | |
| TEST_QTY_UOM | VARCHAR2 | (3) | Test Quanity UOM | |
| TO_QTY_UOM | VARCHAR2 | (3) | To Qty UOM |
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 does not reference any database object
GMD.GMD_SPEC_TESTS_B is referenced by following:
APPS
GMD_SPEC_TESTS_B
|
|
|
|