[Home] [Help] [Dependency Information]
Object Name: | PMITS_QC_TESTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PMI.PMITS_QC_TESTS_V |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TEST_ID | NUMBER | Yes | Test Identifier | |
TEST_CODE | VARCHAR2 | (80) | Yes | Unique Test Code |
TEST_DESC | VARCHAR2 | (240) | Yes | Test Description |
TEST_METHOD_ID | NUMBER | Yes | Identifier which Identifies Test Method | |
TEST_OPRN_LINE_ID | NUMBER | |||
TEST_PROVIDER_CODE | VARCHAR2 | (8) | ||
TEST_CLASS | VARCHAR2 | (8) | Test Class | |
TEST_CLASS_DESC | VARCHAR2 | (80) | ||
TEST_TYPE | VARCHAR2 | (1) | Yes | Test Type of result validation |
TEST_UNIT | VARCHAR2 | (25) | Test Unit. This is kind of UOM for test. | |
MIN_VALUE_NUM | NUMBER | Min Numeric Value allowed for this Test | ||
MAX_VALUE_NUM | NUMBER | Max Numeric Value allowed for this Test | ||
EXP_ERROR_TYPE | VARCHAR2 | (1) | Experimental Error Type | |
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 | VARCHAR2 | (32) | Action code for Below Spec min | |
ABOVE_MIN_ACTION_CODE | VARCHAR2 | (32) | Action code for Above Spec min | |
BELOW_MAX_ACTION_CODE | VARCHAR2 | (32) | Action code for Below Spec max | |
ABOVE_MAX_ACTION_CODE | VARCHAR2 | (32) | Action code for Above Spec max | |
EXPRESSION | VARCHAR2 | (4000) | Expression | |
DISPLAY_PRECISION | NUMBER | (2) | Dispaly Precision for Numeric Values | |
REPORT_PRECISION | NUMBER | (2) | Reporting Precision for Numeric Values | |
PRIORITY | VARCHAR2 | (2) | Priority allowed values Low,Normal and High | |
TEST_OPRN_ID | NUMBER | |||
MIN_NUM | NUMBER | Min Value for Numeric Range display label | ||
MAX_NUM | NUMBER | Max Value for Numeric Range display label | ||
DISPLAY_LABEL_NUMERIC_RANGE | VARCHAR2 | (240) | Numeric Range display Label | |
TEST_VALUE_DESC | VARCHAR2 | (240) | Description for Text values | |
VALUE_CHAR | VARCHAR2 | (16) | Text Value | |
TEXT_RANGE_SEQ | NUMBER | Text Range Seq | ||
EXPRESSION_REF_TEST_ID | NUMBER | Reference Test Id for Expression |
Cut, paste (and edit) the following text to query this object:
SELECT TEST_ID
, TEST_CODE
, TEST_DESC
, TEST_METHOD_ID
, TEST_OPRN_LINE_ID
, TEST_PROVIDER_CODE
, TEST_CLASS
, TEST_CLASS_DESC
, TEST_TYPE
, TEST_UNIT
, MIN_VALUE_NUM
, MAX_VALUE_NUM
, 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
, EXPRESSION
, DISPLAY_PRECISION
, REPORT_PRECISION
, PRIORITY
, TEST_OPRN_ID
, MIN_NUM
, MAX_NUM
, DISPLAY_LABEL_NUMERIC_RANGE
, TEST_VALUE_DESC
, VALUE_CHAR
, TEXT_RANGE_SEQ
, EXPRESSION_REF_TEST_ID
FROM APPS.PMITS_QC_TESTS_V;
APPS.PMITS_QC_TESTS_V is not referenced by any database object
|
|
|