[Home] [Help] [Dependency Information]
Object Name: | GMD_QC_RESULTS_TREE_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
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 |
---|---|---|---|---|
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 |
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;
APPS.GMD_QC_RESULTS_TREE_V is not referenced by any database object
|
|
|