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

VIEW: APPS.PMITS_QC_RESULTS_V

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

View Type

A Business Intelligence System view

[View Source]

Columns
Name Datatype Length Mandatory Comments
RESULT_ID NUMBER

Unique Identifier for Result
SAMPLE_ID NUMBER

Unique Identifier for Sample
TEST_ID NUMBER

Unique Identifier for Test
TEST_REPLICATE_CNT NUMBER

Test Replicate Count
QC_LAB_ORGN_CODE CHAR (3)
QC Lab Organization Code
RESULT_VALUE_NUM NUMBER

Numeric Result
RESULT_DATE DATE

Result Date
TEST_KIT_ITEM_ID NUMBER

Test Kit Item ID
TEST_KIT_LOT_NO CHAR (3)
Test Kit Lot Number
TEST_KIT_SUBLOT_NO CHAR (3)
Test Kit Sublot Number
ADDITIONAL_TEST_IND CHAR (3)
Additional Test Indicator
RESULT_MEANING CHAR (3)
Result Display Label
TESTER CHAR (3)
Tester
TESTER_ID NUMBER

Tester ID
TEST_PROVIDER_ID NUMBER

Test Provider ID
AD_HOC_PRINT_ON_COA_IND CHAR (1)
Adhoc Print on COA Indicator
SEQ NUMBER

Test Sequence
RESULT_VALUE_CHAR CHAR (1)
Text Result
TEST_RESULT CHAR (3)
Test Result. It is a decode on Text Result and Numeric Result
TEST_PROVIDER_CODE CHAR (3)
Test Provider Code
ASSAY_RETEST NUMBER

Assay Retest
RSLT_DELETE_MARK CHAR (3)
Marked for Purge
TEXT_CODE NUMBER

Text Code
SPEC_ID NUMBER

Unique Identifier for Spec
TEST_METHOD_ID NUMBER

Unique Identifier for Test Method
TEST_QTY NUMBER

Test Quantity
TEST_UOM CHAR (3)
Test UOM
SPEC_MIN_VALUE CHAR (3)
Spec Min
SPEC_TARGET_VALUE CHAR (3)
Spec Target
SPEC_MAX_VALUE CHAR (3)
Spec Max
TEST_REPLICATE NUMBER

Replicate
CHECK_RESULT_INTERVAL NUMBER

Check Result Interval
PRINT_ON_COA_IND CHAR (1)
Print on COA Indicator
USE_TO_CONTROL_STEP CHAR (1)
Use to control Step
OUT_OF_SPEC_ACTION CHAR (3)
Out of Spec Action Code
EXP_ERROR_TYPE CHAR (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 CHAR (3)
Below Spec Min Action Code
ABOVE_MIN_ACTION_CODE CHAR (3)
Above Spec Min Action Code
OPTIONAL_IND CHAR (3)
Optional Test Indicator
DISPLAY_PRECISION NUMBER

Numeric Display Precision
REPORT_PRECISION NUMBER

Numeric Reporting Precision
TEST_PRIORITY CHAR (3)
Test Priority
RETEST_LOT_EXPIRY_IND CHAR (3)
Retest Lot Expiry Indicator
PRINT_SPEC_IND CHAR (3)
Print Spec Indicator
PRINT_RESULT_IND CHAR (3)
Print Result Indicator
BELOW_MAX_ACTION_CODE CHAR (3)
Below Spec Max Action Code
ABOVE_MAX_ACTION_CODE CHAR (3)
Above Spec Max Action Code
TEST_DISPLAY CHAR (3)
Test Display
TEST_CODE CHAR (3)
Test Code
TEST_DESC CHAR (3)
Test Description
TEST_OPRN_LINE_ID NUMBER

Test Opration Line ID
TEST_CLASS CHAR (3)
Test Class
TEST_TYPE_DESC CHAR (3)
Test Type Description
TEST_UNIT CHAR (3)
QC Test Unit Code
TEST_MIN_VALUE NUMBER

Test Min Value
TEST_MAX_VALUE NUMBER

Test Max Value
EXPRESSION CHAR (3)
Expression
TEST_METHOD_CODE CHAR (3)
Test Method Code
TEST_METHOD_DESC CHAR (3)
Test Method Description
TEST_DURATION NUMBER

Test Duration
RESOURCES CHAR (3)
Resources
EVALUATION_IND CHAR (3)
Evaluation Indicator
EVALUATION_IND_DISP CHAR (3)
Evaluation Indicator Meaning resolved using GEM LOOKUPS
SPEC_RSLT_ACT_CODE CHAR (3)
Action to be taken
IN_SPEC_IND_DISP CHAR (3)
In Spec Indicator Meaning resolved using GEM LOOKUPS
VALUE_IN_REPORT_PRECISION NUMBER

Value in Report Precision
EVENT_SPEC_DISP_ID NUMBER

Unique Identifier for Event Spec Disposition
EVENT_SPEC_DISP_SMP_EVT_ID NUMBER

Sampling Event Id
EVENT_SPEC_VR_ID NUMBER

Spec Validity Rule Identifier
EVENT_SPEC_DISP CHAR (3)
Event Spec Disposition
SPEC_USED_FOR_LOT_ATTRIB_IND CHAR (1)
Current Spec Results used to set Lot Attributes
EVT_SPEC_LOT_ATTR_IND_DISP CHAR (3)
Current Spec Results used to set Lot Attributes Meaning
EVT_SPEC_DISP_DEL_MARK CHAR (3)
Event Spec Disp delete Mark
SPEC_TARGET_MEANING CHAR (3)
Spec Traget Meaning resolved using est Values
SPEC_MIN_MEANING CHAR (3)
Spec Min Meaning resolved using Test Values
SPEC_MAX_MEANING CHAR (3)
Spec Max Meaning resolved using Test Values
TEST_MIN_MEANING CHAR (3)
Test Level Min resolved using Test Values
TEST_MAX_MEANING CHAR (3)
Test Level Max resolved using Test Values
Query Text

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


SELECT RESULT_ID
,      SAMPLE_ID
,      TEST_ID
,      TEST_REPLICATE_CNT
,      QC_LAB_ORGN_CODE
,      RESULT_VALUE_NUM
,      RESULT_DATE
,      TEST_KIT_ITEM_ID
,      TEST_KIT_LOT_NO
,      TEST_KIT_SUBLOT_NO
,      ADDITIONAL_TEST_IND
,      RESULT_MEANING
,      TESTER
,      TESTER_ID
,      TEST_PROVIDER_ID
,      AD_HOC_PRINT_ON_COA_IND
,      SEQ
,      RESULT_VALUE_CHAR
,      TEST_RESULT
,      TEST_PROVIDER_CODE
,      ASSAY_RETEST
,      RSLT_DELETE_MARK
,      TEXT_CODE
,      SPEC_ID
,      TEST_METHOD_ID
,      TEST_QTY
,      TEST_UOM
,      SPEC_MIN_VALUE
,      SPEC_TARGET_VALUE
,      SPEC_MAX_VALUE
,      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
,      OPTIONAL_IND
,      DISPLAY_PRECISION
,      REPORT_PRECISION
,      TEST_PRIORITY
,      RETEST_LOT_EXPIRY_IND
,      PRINT_SPEC_IND
,      PRINT_RESULT_IND
,      BELOW_MAX_ACTION_CODE
,      ABOVE_MAX_ACTION_CODE
,      TEST_DISPLAY
,      TEST_CODE
,      TEST_DESC
,      TEST_OPRN_LINE_ID
,      TEST_CLASS
,      TEST_TYPE_DESC
,      TEST_UNIT
,      TEST_MIN_VALUE
,      TEST_MAX_VALUE
,      EXPRESSION
,      TEST_METHOD_CODE
,      TEST_METHOD_DESC
,      TEST_DURATION
,      RESOURCES
,      EVALUATION_IND
,      EVALUATION_IND_DISP
,      SPEC_RSLT_ACT_CODE
,      IN_SPEC_IND_DISP
,      VALUE_IN_REPORT_PRECISION
,      EVENT_SPEC_DISP_ID
,      EVENT_SPEC_DISP_SMP_EVT_ID
,      EVENT_SPEC_VR_ID
,      EVENT_SPEC_DISP
,      SPEC_USED_FOR_LOT_ATTRIB_IND
,      EVT_SPEC_LOT_ATTR_IND_DISP
,      EVT_SPEC_DISP_DEL_MARK
,      SPEC_TARGET_MEANING
,      SPEC_MIN_MEANING
,      SPEC_MAX_MEANING
,      TEST_MIN_MEANING
,      TEST_MAX_MEANING
FROM APPS.PMITS_QC_RESULTS_V;

Dependencies

[top of page]

APPS.PMITS_QC_RESULTS_V references the following:

SchemaPUBLIC
SynonymDUAL

APPS.PMITS_QC_RESULTS_V is not referenced by any database object