DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.PMITS_QC_TESTS_V

Object Details
Object Name: PMITS_QC_TESTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPMI.PMITS_QC_TESTS_V
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view

[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.PMITS_QC_TESTS_V references the following:

SchemaAPPS
ViewGMD_QC_TESTS_VL
ViewGMD_QC_TEST_VALUES_VL
ViewGMD_TEST_CLASSES_VL

APPS.PMITS_QC_TESTS_V is not referenced by any database object