APPS.GMD_QC_LABELS_UTIL dependencies on GMD_SAMPLES

Line 85: FROM GMD_SAMPLES

81: sample_qty, sample_qty_uom, subinventory, locator_id, parent_lot_number, lot_number,
82: lab_organization_id, expiration_date, lot_retest_ind, storage_organization_id, storage_subinventory,
83: storage_locator_id, sample_instance,date_drawn, resources, instance_id,
84: time_point_id, retain_as
85: FROM GMD_SAMPLES
86: WHERE ((p_organization_id IS NULL) OR (ORGANIZATION_ID = p_organization_id))
87: AND ((p_from_sample_no IS NULL) OR (sample_no between p_from_sample_no and p_to_sample_no))
88: AND ((p_variant_id IS NULL) OR (variant_id = p_variant_id))
89: AND ((p_time_point_id IS NULL ) OR (time_point_id = p_time_point_id))

Line 134: gmd_samples gsmp ,

130: oeoha.order_number order_number,
131: oetrtyp.NAME order_type ,
132: oeola.line_number order_line_number
133: FROM
134: gmd_samples gsmp ,
135: hz_parties hzp ,
136: hz_cust_accounts_all hzca ,
137: hr_all_organization_units_tl hrou ,
138: HR_ORGANIZATION_INFORMATION O2,

Line 178: gmd_samples gsmp ,

174: polinesall.line_num po_line_number ,
175: rcvshiphdr.receipt_num receipt_number ,
176: rcvshiplines.line_num receipt_line_number
177: FROM
178: gmd_samples gsmp ,
179: po_vendors povend ,
180: po_vendor_sites_all povendsites ,
181: po_headers_all pohdrall ,
182: po_lines_all polinesall ,

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