[Home] [Help]
View: GMD_QM_E_TIMEPOINTS_V
Product: | GMD - Process Manufacturing Product Development |
Description: | OPM Quality Timepoint ERES View |
Implementation/DBA Data: |
APPS.GMD_QM_E_TIMEPOINTS_V
|
View Text
SELECT C.VARIANT_ID
, C.TIME_POINT_ID
, I.SPEC_NAME
, I.SPEC_VERS
, PERIOD_ID
, NAME
, WF_SENT
, SAMPLES_PER_TIME_POINT
, SCHEDULED_DATE
, ACTUAL_DATE
, SAMPLING_EVENT_ID
, I.SPEC_STATUS
FROM GMD_SS_TIME_POINTS C
, GMD_SPECIFICATIONS I
WHERE I.SPEC_ID = C.SPEC_ID
Columns
Name |
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 |