eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.GMD_QC_E_RESULTS_V

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	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

Query Text

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;

Dependencies

[top of page]

APPS.GMD_QC_E_RESULTS_V references the following:

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