DBA Data[Home] [Help]

APPS.GMD_QC_LABELS_UTIL dependencies on GMD_STABILITY_STUDIES

Line 210: GMD_SAMPLES E,GMD_STABILITY_STUDIES f

206: d.spec_name storage_spec, d.spec_vers storage_spec_version,
207: a.variant_no, b.name time_interval_name, b.scheduled_date
208: FROM GMD_SS_VARIANTS A, GMD_SS_TIME_POINTS B,
209: GMD_SPECIFICATIONS_B C, GMD_SPECIFICATIONS D,
210: GMD_SAMPLES E,GMD_STABILITY_STUDIES f
211: WHERE e.sample_id = p_sample_id
212: AND e.variant_id = p_variant_id
213: AND e.time_point_id = b.time_point_id
214: AND e.variant_id = b.variant_id

Line 229: GMD_SAMPLES E,GMD_STABILITY_STUDIES f

225: d.spec_name storage_spec, d.spec_vers storage_spec_version,
226: a.variant_no, null time_interval_name, null scheduled_date --null for retained sample.
227: FROM GMD_SS_VARIANTS A,
228: GMD_SPECIFICATIONS_B C, GMD_SPECIFICATIONS D,
229: GMD_SAMPLES E,GMD_STABILITY_STUDIES f
230: WHERE e.sample_id = p_sample_id
231: AND e.variant_id = p_variant_id
232: AND e.variant_id = a.variant_id
233: AND a.default_spec_id = c.spec_id