[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GMD_QC_E_RESULTS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  GMD.GMD_QC_E_RESULTS_V
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| RSLT_UPD_INST_ID | NUMBER | To store e-signature instance identification | ||
| SPEC_RSLT_UPD_INST_ID | NUMBER | To Store e-signature Instance Identification | ||
| RESULT_ID | NUMBER | Results unique identifier | ||
| SAMPLE_ID | NUMBER | Identifies the sample the test results is recorded | ||
| TEST_ID | NUMBER | Test performed the results are recorded | ||
| TEST_REPLICATE_CNT | NUMBER | Number of times test performed on same sample | ||
| LAB_ORGANIZATION_ID | NUMBER | Laboratory Organization | ||
| RESULT_VALUE_NUM | NUMBER | Numeric result value | ||
| RESULT_DATE | DATE | Date result occurred | ||
| TEST_KIT_INV_ITEM_ID | NUMBER | Test Kit Inventory Item | ||
| TEST_KIT_LOT_NUMBER | VARCHAR2 | (80) | Test Kit Lot Number | |
| ADDITIONAL_TEST_IND | VARCHAR2 | (80) | ||
| RESULT_MEANING | VARCHAR2 | (4000) | ||
| TESTER | VARCHAR2 | (30) | ||
| TESTER_ID | NUMBER | |||
| TEST_PROVIDER_ID | NUMBER | |||
| AD_HOC_PRINT_ON_COA_IND | VARCHAR2 | (1) | ||
| SEQ | NUMBER | |||
| RESULT_VALUE_CHAR | VARCHAR2 | (80) | ||
| TEST_RESULT | VARCHAR2 | (80) | ||
| TEST_PROVIDER_CODE | VARCHAR2 | (8) | ||
| ASSAY_RETEST | NUMBER | (8) | ||
| RSLT_DELETE_MARK | VARCHAR2 | (80) | ||
| TEXT_CODE | NUMBER | (10) | ||
| SPEC_ID | NUMBER | |||
| TEST_METHOD_ID | NUMBER | |||
| TEST_QTY_UOM | VARCHAR2 | (3) | ||
| SPEC_MIN_VALUE | VARCHAR2 | (40) | ||
| SPEC_TARGET_VALUE | VARCHAR2 | (40) | ||
| SPEC_MAX_VALUE | VARCHAR2 | (40) | ||
| TEST_REPLICATE | NUMBER | |||
| CHECK_RESULT_INTERVAL | NUMBER | |||
| PRINT_ON_COA_IND | VARCHAR2 | (1) | ||
| USE_TO_CONTROL_STEP | VARCHAR2 | (1) | ||
| OUT_OF_SPEC_ACTION | VARCHAR2 | (32) | ||
| EXP_ERROR_TYPE | VARCHAR2 | (1) | ||
| BELOW_SPEC_MIN | NUMBER | |||
| ABOVE_SPEC_MIN | NUMBER | |||
| BELOW_SPEC_MAX | NUMBER | |||
| ABOVE_SPEC_MAX | NUMBER | |||
| BELOW_MIN_ACTION_CODE | VARCHAR2 | (32) | ||
| ABOVE_MIN_ACTION_CODE | VARCHAR2 | (32) | ||
| OPTIONAL_IND | VARCHAR2 | (80) | ||
| DISPLAY_PRECISION | NUMBER | (2) | ||
| REPORT_PRECISION | NUMBER | (2) | ||
| TEST_PRIORITY | VARCHAR2 | (80) | ||
| RETEST_LOT_EXPIRY_IND | VARCHAR2 | (80) | ||
| PRINT_SPEC_IND | VARCHAR2 | (80) | ||
| PRINT_RESULT_IND | VARCHAR2 | (80) | ||
| BELOW_MAX_ACTION_CODE | VARCHAR2 | (32) | ||
| ABOVE_MAX_ACTION_CODE | VARCHAR2 | (32) | ||
| TEST_DISPLAY | VARCHAR2 | (240) | ||
| TEST_CODE | VARCHAR2 | (80) | ||
| TEST_DESC | VARCHAR2 | (240) | ||
| TEST_OPRN_LINE_ID | NUMBER | |||
| TEST_CLASS | VARCHAR2 | (8) | ||
| TEST_TYPE_DESC | VARCHAR2 | (80) | ||
| TEST_UNIT | VARCHAR2 | (25) | ||
| TEST_MIN_VALUE | NUMBER | |||
| TEST_MAX_VALUE | NUMBER | |||
| EXPRESSION | VARCHAR2 | (4000) | ||
| TEST_METHOD_CODE | VARCHAR2 | (80) | ||
| TEST_METHOD_DESC | VARCHAR2 | (240) | ||
| TEST_DURATION | NUMBER | (10) | ||
| RESOURCES | VARCHAR2 | (16) | ||
| EVALUATION_IND | VARCHAR2 | (2) | ||
| SPEC_RSLT_ACT_CODE | VARCHAR2 | (32) | ||
| IN_SPEC_IND_DISP | VARCHAR2 | (80) | ||
| VALUE_IN_REPORT_PRECISION | NUMBER | |||
| EVENT_SPEC_DISP_ID | NUMBER | |||
| EVENT_SPEC_DISP_SMP_EVT_ID | NUMBER | |||
| EVENT_SPEC_VR_ID | NUMBER | |||
| EVENT_SPEC_DISP | VARCHAR2 | (3) | ||
| EVT_SPEC_LOT_ATTR_IND_DISP | VARCHAR2 | (80) | ||
| EVT_SPEC_DISP_DEL_MARK | VARCHAR2 | (80) | ||
| SPEC_TARGET_MEANING | VARCHAR2 | (4000) | ||
| SPEC_MIN_MEANING | VARCHAR2 | (4000) | ||
| SPEC_MAX_MEANING | VARCHAR2 | (4000) | ||
| TEST_MIN_MEANING | VARCHAR2 | (4000) | ||
| TEST_MAX_MEANING | VARCHAR2 | (4000) | ||
| CONSUMED_QTY | NUMBER | |||
| ACTUAL_RESOURCE | VARCHAR2 | (30) | ||
| ACTUAL_RESOURCE_INSTANCE | NUMBER | |||
| PLANNED_RESOURCE | VARCHAR2 | (30) | ||
| PLANNED_RESOURCE_INSTANCE | NUMBER | |||
| PLANNED_RESULT_DATE | DATE | |||
| TEST_QTY | NUMBER | |||
| TEST_UOM | VARCHAR2 | (3) | ||
| PARENT_RESULT_ID | NUMBER | |||
| RESERVE_SAMPLE_ID | NUMBER | |||
| PARENT_SAMPLE_NO | VARCHAR2 | (84) | ||
| RESERVE_SAMPLE_NO | VARCHAR2 | (80) | ||
| TEST_TARGET_VALUE | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT RSLT_UPD_INST_ID
, SPEC_RSLT_UPD_INST_ID
, RESULT_ID
, SAMPLE_ID
, TEST_ID
, TEST_REPLICATE_CNT
, LAB_ORGANIZATION_ID
, RESULT_VALUE_NUM
, RESULT_DATE
, TEST_KIT_INV_ITEM_ID
, TEST_KIT_LOT_NUMBER
, 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_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
, 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
, 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
, CONSUMED_QTY
, ACTUAL_RESOURCE
, ACTUAL_RESOURCE_INSTANCE
, PLANNED_RESOURCE
, PLANNED_RESOURCE_INSTANCE
, PLANNED_RESULT_DATE
, TEST_QTY
, TEST_UOM
, PARENT_RESULT_ID
, RESERVE_SAMPLE_ID
, PARENT_SAMPLE_NO
, RESERVE_SAMPLE_NO
, TEST_TARGET_VALUE
FROM APPS.GMD_QC_E_RESULTS_V;
APPS
FND_LOOKUP_VALUES_VL
GMD_EVENT_SPEC_DISP
GMD_QC_TESTS
GMD_QC_TEST_VALUES_GRP
- show dependent code
GMD_RESULTS
GMD_SAMPLES
GMD_SPEC_RESULTS
GMD_SPEC_TESTS
GMD_TEST_METHODS
MTL_PARAMETERS
APPS.GMD_QC_E_RESULTS_V is not referenced by any database object
|
|
|
|