DBA Data[Home] [Help]

VIEW: APPS.GMD_QM_E_TIMEPOINTS_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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