APPS.GMD_QC_LABELS_UTIL dependencies on GMD_SS_VARIANTS

Line 208: FROM GMD_SS_VARIANTS A, GMD_SS_TIME_POINTS B,

204: IS
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

Line 227: FROM GMD_SS_VARIANTS A,

223: IS
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

Line 246: FROM GMP_RESOURCE_INSTANCES a, GMD_SS_VARIANTS B

242: -- changed storage_location to storage_locator_id.
243:
244: CURSOR c_get_variant_storage IS
245: SELECT a.instance_number, b.resources, b.storage_organization_id, b.storage_subinventory, b.storage_locator_id
246: FROM GMP_RESOURCE_INSTANCES a, GMD_SS_VARIANTS B
247: WHERE a.INSTANCE_ID(+) = b.resource_instance_id
248: AND b.variant_id = p_variant_id;
249: c_variant_storage_row c_get_variant_storage%ROWTYPE;
250: