[Home] [Help] [Dependency Information]
Object Name: | GMD_QC_E_COMPOSITE_RESULTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GMD.GMD_QC_E_COMPOSITE_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 |
---|---|---|---|---|
EVENT_SPEC_DISP_ID | NUMBER | Yes | Event specification disposition ID | |
COMPOSITE_SPEC_DISP_ID | NUMBER | Yes | Composite Specification Display Identifier | |
DISPOSITION | VARCHAR2 | (3) | Yes | Disposition |
EXPRESSION | VARCHAR2 | (4000) | ||
LATEST_IND | VARCHAR2 | (1) | ||
COMPOSITE_RESULT_ID | NUMBER | Yes | ||
TEST_ID | NUMBER | Yes | ||
MEAN | NUMBER | |||
MODE_VALUE | VARCHAR2 | (80) | ||
LOW_VALUE | VARCHAR2 | (80) | ||
HIGH_VALUE | VARCHAR2 | (80) | ||
RANGE | NUMBER | |||
STANDARD_DEVIATION | NUMBER | |||
SAMPLE_TOTAL | NUMBER | |||
SAMPLE_CNT_USED | NUMBER | |||
NON_VALIDATED_RESULT | VARCHAR2 | (80) | ||
MEDIAN_VALUE | VARCHAR2 | (80) | ||
IN_SPEC_IND_DISP | VARCHAR2 | (80) | ||
VALUE_IN_REPORT_PRECISION | NUMBER | |||
TEST_CODE | VARCHAR2 | (80) | Yes | |
TEST_DESC | VARCHAR2 | (240) | Yes | |
TEST_UNIT | VARCHAR2 | (25) | ||
TEST_CLASS | VARCHAR2 | (8) | ||
TEST_TYPE_DESC | VARCHAR2 | (80) | Yes | |
TEST_PRIORITY_DESC | VARCHAR2 | (80) | Yes | |
TEST_METHOD_CODE | VARCHAR2 | (80) | Yes | |
TEST_METHOD_DESC | VARCHAR2 | (240) | Yes | |
SPEC_MIN_VALUE | VARCHAR2 | (40) | ||
SPEC_TARGET_VALUE | VARCHAR2 | (40) | ||
SPEC_MAX_VALUE | VARCHAR2 | (40) | ||
SPEC_TARGET_MEANING | VARCHAR2 | (4000) | ||
SPEC_MIN_MEANING | VARCHAR2 | (4000) | ||
SPEC_MAX_MEANING | VARCHAR2 | (4000) |
Cut, paste (and edit) the following text to query this object:
SELECT EVENT_SPEC_DISP_ID
, COMPOSITE_SPEC_DISP_ID
, DISPOSITION
, EXPRESSION
, LATEST_IND
, COMPOSITE_RESULT_ID
, TEST_ID
, MEAN
, MODE_VALUE
, LOW_VALUE
, HIGH_VALUE
, RANGE
, STANDARD_DEVIATION
, SAMPLE_TOTAL
, SAMPLE_CNT_USED
, NON_VALIDATED_RESULT
, MEDIAN_VALUE
, IN_SPEC_IND_DISP
, VALUE_IN_REPORT_PRECISION
, TEST_CODE
, TEST_DESC
, TEST_UNIT
, TEST_CLASS
, TEST_TYPE_DESC
, TEST_PRIORITY_DESC
, TEST_METHOD_CODE
, TEST_METHOD_DESC
, SPEC_MIN_VALUE
, SPEC_TARGET_VALUE
, SPEC_MAX_VALUE
, SPEC_TARGET_MEANING
, SPEC_MIN_MEANING
, SPEC_MAX_MEANING
FROM APPS.GMD_QC_E_COMPOSITE_RESULTS_V;
APPS.GMD_QC_E_COMPOSITE_RESULTS_V is not referenced by any database object
|
|
|