[Home] [Help] [Dependency Information]
Object Name: | GMD_QM_E_TIMEPOINTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GMD.GMD_QM_E_TIMEPOINTS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
OPM Quality Timepoint ERES View
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
VARIANT_ID | NUMBER | Yes | variant id | |
TIME_POINT_ID | NUMBER | Yes | time point id | |
SPEC_NAME | VARCHAR2 | (80) | Yes | spec name |
SPEC_VERS | NUMBER | (10) | Yes | spec version |
PERIOD_ID | NUMBER | period | ||
NAME | VARCHAR2 | (80) | Yes | Time point Name |
WF_SENT | VARCHAR2 | (2) | Workflow Sent | |
SAMPLES_PER_TIME_POINT | NUMBER | samples per timepoint | ||
SCHEDULED_DATE | DATE | scheduled Date | ||
ACTUAL_DATE | DATE | actual date | ||
SAMPLING_EVENT_ID | NUMBER | sampling event id | ||
TIMEPOINT_DISPOSITION | NUMBER | (5) | Yes | Timepoint Disposition |
Cut, paste (and edit) the following text to query this object:
SELECT VARIANT_ID
, TIME_POINT_ID
, SPEC_NAME
, SPEC_VERS
, PERIOD_ID
, NAME
, WF_SENT
, SAMPLES_PER_TIME_POINT
, SCHEDULED_DATE
, ACTUAL_DATE
, SAMPLING_EVENT_ID
, TIMEPOINT_DISPOSITION
FROM APPS.GMD_QM_E_TIMEPOINTS_V;
APPS.GMD_QM_E_TIMEPOINTS_V is not referenced by any database object
|
|
|