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_RESULTS_TREE_V

Object Details

Object Name:	GMD_QC_RESULTS_TREE_V
Object Type:	VIEW
Owner:	APPS
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	Mandatory	Comments
ORGANIZATION_ID	NUMBER			Organization Identifier
ORG_CODE	VARCHAR2	(3)		Organization Code
SAMPLE_ID	NUMBER		Yes	Sample Identifier
SAMPLE_NO	VARCHAR2	(80)	Yes	Sample Number
SAMPLE_DESC	VARCHAR2	(80)		Sample Description
DATE_DRAWN	DATE			Date Sample Drawn
SAMPLING_EVENT_ID	NUMBER		Yes	Sampling Event Identifier
SOURCE	VARCHAR2	(1)	Yes	Sample Source
DISPOSITION	VARCHAR2	(3)	Yes	Sample Disposition Code
SAMPLE_DISPOSITION	VARCHAR2	(80)	Yes	Sample Disposition
RESULT_ID	NUMBER		Yes	Result Identifier
SEQ	NUMBER		Yes	Test Sequence
TEST_ID	NUMBER		Yes	Test Identifier
TEST_CODE	VARCHAR2	(80)	Yes	Test Code
TEST_TYPE	VARCHAR2	(1)	Yes	Test Type Code
TEST_TYPE_MEANING	VARCHAR2	(80)	Yes	Test Type Meaning
PRIORITY	VARCHAR2	(2)		Test Priority Code
TEST_PRIORITY	VARCHAR2	(80)	Yes	Test Priority
TEST_METHOD_ID	NUMBER		Yes	Test Method Identifier
TEST_METHOD_CODE	VARCHAR2	(80)	Yes	Test Method Code
TEST_REPLICATE_CNT	NUMBER			Test Replicate Count
RESULT_DATE	DATE			Result Date
RESULT_VALUE_NUM	NUMBER			Result Value Number
RESULT_VALUE_CHAR	VARCHAR2	(80)		Result Value Characters
TEST_RESULT	VARCHAR2	(80)		Test Result
PARENT_RESULT_ID	NUMBER			Parent Result Identifier
RESERVE_SAMPLE_ID	NUMBER			Reserve Sample Identifier
TESTER_ID	NUMBER			Tester Identifier
EVALUATION_IND	VARCHAR2	(2)		Evaluation Indicator
RESULT_EVALUATION	VARCHAR2	(80)		Result Evaluation
SPEC_ID	NUMBER			Specification Identifier
ADDITIONAL_TEST_IND	VARCHAR2	(1)		Additional Test Indicator
TESTS_DELETE_MARK	NUMBER	(5)	Yes	Delete Mark for Test
RESULTS_DELETE_MARK	NUMBER		Yes	Delete Mark for Result
OPTIONAL_IND	VARCHAR2	(1)		Optional Indicator
SPEC_TEST_PRIORITY	VARCHAR2	(2)		Specification Test Priority
LAB_ORGANIZATION_ID	NUMBER			Lab Organiation Identifier
LAB_ORGN_CODE	VARCHAR2	(3)		Lab Organization Code

Query Text

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


SELECT ORGANIZATION_ID
,      ORG_CODE
,      SAMPLE_ID
,      SAMPLE_NO
,      SAMPLE_DESC
,      DATE_DRAWN
,      SAMPLING_EVENT_ID
,      SOURCE
,      DISPOSITION
,      SAMPLE_DISPOSITION
,      RESULT_ID
,      SEQ
,      TEST_ID
,      TEST_CODE
,      TEST_TYPE
,      TEST_TYPE_MEANING
,      PRIORITY
,      TEST_PRIORITY
,      TEST_METHOD_ID
,      TEST_METHOD_CODE
,      TEST_REPLICATE_CNT
,      RESULT_DATE
,      RESULT_VALUE_NUM
,      RESULT_VALUE_CHAR
,      TEST_RESULT
,      PARENT_RESULT_ID
,      RESERVE_SAMPLE_ID
,      TESTER_ID
,      EVALUATION_IND
,      RESULT_EVALUATION
,      SPEC_ID
,      ADDITIONAL_TEST_IND
,      TESTS_DELETE_MARK
,      RESULTS_DELETE_MARK
,      OPTIONAL_IND
,      SPEC_TEST_PRIORITY
,      LAB_ORGANIZATION_ID
,      LAB_ORGN_CODE
FROM APPS.GMD_QC_RESULTS_TREE_V;

Dependencies

[top of page]

APPS.GMD_QC_RESULTS_TREE_V references the following:

APPS: GEM_LOOKUPS; GMD_EVENT_SPEC_DISP; GMD_QC_TESTS; GMD_RESULTS; GMD_SAMPLES; GMD_SAMPLE_SPEC_DISP; GMD_SPEC_RESULTS; GMD_SPEC_TESTS; GMD_TEST_METHODS; MTL_PARAMETERS

APPS.GMD_QC_RESULTS_TREE_V is not referenced by any database object