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

VIEW: APPS.PMITS_QC_SPEC_TESTS_V

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

View Type

A Business Intelligence System view

[View Source]

Columns
Name Datatype Length Mandatory Comments
SPEC_ID NUMBER

Unique Identifier for Spec
TEST_ID NUMBER

Unique Identifier for Test
TEST_METHOD_ID NUMBER

Unique Identifier for Test method
SEQ NUMBER

Test Sequence
TEST_METHOD_CODE CHAR (3)
Test Method Code
TEST_REPLICATE NUMBER

Replicate
TEST_QTY NUMBER

Test Qty
TEST_UOM CHAR (3)
Test UOM
SPEC_MIN_VALUE CHAR (3)
Spec Min. This includes both Spec Min Char and Num
SPEC_TARGET_VALUE CHAR (3)
Spec Target.This includes both Spec Target Char and Num
SPEC_MAX_VALUE CHAR (3)
Spec Max. This includes both Spec Max Char and Num
MIN_VALUE_NUM NUMBER

Spec Numeric Min
TARGET_VALUE_NUM NUMBER

Spec Target Numeric
MAX_VALUE_NUM NUMBER

Spec Max Numeric
MIN_VALUE_CHAR CHAR (3)
Spec Min Char
TARGET_VALUE_CHAR CHAR (3)
Spec Target Char
MAX_VALUE_CHAR CHAR (3)
Spec Max Char
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 CHAR (3)
Below Spec Min Action Code
ABOVE_MIN_ACTION_CODE CHAR (3)
Above Spec Min Action Code
BELOW_MAX_ACTION_CODE CHAR (3)
Below Spec Max Action Code
ABOVE_MAX_ACTION_CODE CHAR (3)
Above Spec Max Action Code
OPTIONAL_IND CHAR (3)
Optional Test Indicator
DISPLAY_PRECISION NUMBER

Numeric Result Display Precision
REPORT_PRECISION NUMBER

Numeric Result Reporting Precision
OUT_OF_SPEC_ACTION CHAR (3)
Out of spec Action
TEST_PRIORITY CHAR (3)
Test Priority
RETEST_LOT_EXPIRY_IND CHAR (3)
Lot Retest / Expiry Indicator
EXP_ERROR_TYPE CHAR (3)
Experimental Error Type
PRINT_SPEC_IND CHAR (3)
Print Spec Indicator
PRINT_RESULT_IND CHAR (3)
Print Result Indicator
TEST_DISPLAY CHAR (3)
Test Display
TEXT_CODE NUMBER

Test Code
OUT_OF_SPEC_ACTION_DESC CHAR (3)
Out of spec Action Description
OUT_OF_SPEC_ACTION_INTERVAL NUMBER

Out of Spec Action Interval
EXPRESSION CHAR (3)
Expression
TEST_CODE CHAR (3)
Test Code
TEST_DESC CHAR (3)
Test Description
TEST_UNIT CHAR (3)
QC Unit Code
TEST_TYPE CHAR (3)
Test Type
TEST_TYPE_DESC CHAR (3)
Test Type meaning resolved using GEM LOOKUPS
TEST_CLASS CHAR (3)
Test Class
TEST_MIN_VALUE NUMBER

Min Value allowed as per test definition
TEST_MAX_VALUE NUMBER

Max Value allowed as per test definition
SPEC_TARGET_MEANING CHAR (3)
Target Meaning
SPEC_MIN_MEANING CHAR (3)
Spec Min Meaning
SPEC_MAX_MEANING CHAR (3)
Spec Max Meaning
TEST_MIN_MEANING CHAR (3)
Test Min Meaning
TEST_MAX_MEANING CHAR (3)
Test Max Meaning
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SPEC_ID
,      TEST_ID
,      TEST_METHOD_ID
,      SEQ
,      TEST_METHOD_CODE
,      TEST_REPLICATE
,      TEST_QTY
,      TEST_UOM
,      SPEC_MIN_VALUE
,      SPEC_TARGET_VALUE
,      SPEC_MAX_VALUE
,      MIN_VALUE_NUM
,      TARGET_VALUE_NUM
,      MAX_VALUE_NUM
,      MIN_VALUE_CHAR
,      TARGET_VALUE_CHAR
,      MAX_VALUE_CHAR
,      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
,      OUT_OF_SPEC_ACTION
,      TEST_PRIORITY
,      RETEST_LOT_EXPIRY_IND
,      EXP_ERROR_TYPE
,      PRINT_SPEC_IND
,      PRINT_RESULT_IND
,      TEST_DISPLAY
,      TEXT_CODE
,      OUT_OF_SPEC_ACTION_DESC
,      OUT_OF_SPEC_ACTION_INTERVAL
,      EXPRESSION
,      TEST_CODE
,      TEST_DESC
,      TEST_UNIT
,      TEST_TYPE
,      TEST_TYPE_DESC
,      TEST_CLASS
,      TEST_MIN_VALUE
,      TEST_MAX_VALUE
,      SPEC_TARGET_MEANING
,      SPEC_MIN_MEANING
,      SPEC_MAX_MEANING
,      TEST_MIN_MEANING
,      TEST_MAX_MEANING
FROM APPS.PMITS_QC_SPEC_TESTS_V;

Dependencies

[top of page]

APPS.PMITS_QC_SPEC_TESTS_V references the following:

SchemaPUBLIC
SynonymDUAL

APPS.PMITS_QC_SPEC_TESTS_V is not referenced by any database object