[Home] [Help] [Dependency Information]
Object Name: | PMITS_QC_RESULTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PMI.PMITS_QC_RESULTS_V |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
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 |
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;
APPS.PMITS_QC_RESULTS_V is not referenced by any database object
|
|
|