DBA Data[Home] [Help]

APPS.GMD_QC_LABELS_UTIL dependencies on GMD_SPECIFICATIONS_B

Line 209: GMD_SPECIFICATIONS_B C, GMD_SPECIFICATIONS D,

205: SELECT f.organization_id, f.ss_no,c.spec_name item_spec, c.spec_vers item_spec_version,
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

Line 228: GMD_SPECIFICATIONS_B C, GMD_SPECIFICATIONS D,

224: SELECT f.organization_id, f.ss_no,c.spec_name item_spec, c.spec_vers item_spec_version,
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