[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 |