[Home] [Help] [Dependency Information]
Object Name: | GMD_QC_E_SAMPLE_RESULTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GMD.GMD_QC_E_SAMPLE_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 |
---|---|---|---|---|
SAMPLE_ID | NUMBER | Yes | Sample Unique Identifier; db-seq | |
SAMPLE_NO | VARCHAR2 | (80) | Yes | Sampling Number |
SAMPLE_DESC | VARCHAR2 | (80) | Sampling Description | |
UPDATE_INSTANCE_ID | NUMBER | To store e-signature instance identification | ||
RESULT_ID | NUMBER | Yes | Results unique identifier | |
TEST_ID | NUMBER | Yes | Test performed the results are recorded | |
TEST_RESULT | VARCHAR2 | (80) | ||
TEST_UNIT | VARCHAR2 | (25) | ||
RESULT_DATE | DATE | |||
USER_NAME | VARCHAR2 | (100) | ||
ORGANIZATION_CODE | VARCHAR2 | (3) | ||
TEST_REPLICATE_CNT | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT SAMPLE_ID
, SAMPLE_NO
, SAMPLE_DESC
, UPDATE_INSTANCE_ID
, RESULT_ID
, TEST_ID
, TEST_RESULT
, TEST_UNIT
, RESULT_DATE
, USER_NAME
, ORGANIZATION_CODE
, TEST_REPLICATE_CNT
FROM APPS.GMD_QC_E_SAMPLE_RESULTS_V;
APPS.GMD_QC_E_SAMPLE_RESULTS_V is not referenced by any database object
|
|
|