eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_SS_WFLOW_GRP dependencies on GMD_SS_VARIANTS

Line 99: FROM GMD_SS_VARIANTS v

95: CURSOR c_get_variant IS
96: SELECT ss_id,
97: sample_qty,
98: sample_quantity_uom --INVCONV
99: FROM GMD_SS_VARIANTS v
100: WHERE v.variant_id = p_variant_id;
101: var_rec c_get_variant%ROWTYPE;
102:
103: -- M. Grosser 12-Apr-2006 BUG 4695552 - Modified procedures variant_retianed_sample and events_for_status_change

Line 263: FROM GMD_SS_VARIANTS

259: default_spec_id,
260: /* default_spec_vr_id, */
261: sample_qty,
262: sample_quantity_uom
263: FROM GMD_SS_VARIANTS
264: WHERE material_source_id = mat_rec.source_id;
265:
266: var_rec c_get_var%ROWTYPE;
267: CURSOR c_get_tp IS

Line 277: SELECT 'X' FROM gmd_ss_variants gsv

273: WHERE tp.variant_id = var_rec.variant_id ;
274: tp_rec c_get_tp%ROWTYPE;
275:
276: CURSOR cr_sampling_event_created IS
277: SELECT 'X' FROM gmd_ss_variants gsv
278: where gsv.ss_id = p_ss_id
279: and exists
280: ( select 'x' from gmd_sampling_events gse
281: where gse.variant_id = gsv.variant_id ) ;

Line 448: -- GMD_SS_VARIANTS is updated with the sampling_event_id for the

444: --values
445: -- ( 'Var: sampling_event_id = '||
446: -- x_sampling_event.sampling_event_id );
447: --commit;
448: -- GMD_SS_VARIANTS is updated with the sampling_event_id for the
449: -- Variant's retained samples. The variant's retained samples are
450: -- associated with the same sampling event.
451: UPDATE gmd_ss_variants
452: set sampling_event_id =

Line 451: UPDATE gmd_ss_variants

447: --commit;
448: -- GMD_SS_VARIANTS is updated with the sampling_event_id for the
449: -- Variant's retained samples. The variant's retained samples are
450: -- associated with the same sampling event.
451: UPDATE gmd_ss_variants
452: set sampling_event_id =
453: x_sampling_event.sampling_event_id
454: WHERE variant_id = var_rec.variant_id;
455: p_event_spec_disp.sampling_event_id :=

Line 543: /* GMD_SS_VARIANTS is updated with the sampling_event_id for the

539: values
540: ( 'sampling_event_id = '||
541: x_sampling_event.sampling_event_id );
542: commit; */
543: /* GMD_SS_VARIANTS is updated with the sampling_event_id for the
544: -- Variant's retained samples. The variant's retained samples are
545: -- associated with the same sampling event. */
546: UPDATE gmd_ss_time_points
547: set sampling_event_id =

Line 641: /* GMD_SS_VARIANTS is updated with the sampling_event_id for the

637: values
638: ( 'Var: sampling_event_id = '||
639: x_sampling_event.sampling_event_id );
640: commit; */
641: /* GMD_SS_VARIANTS is updated with the sampling_event_id for the
642: -- Variant's retained samples. The variant's retained samples are
643: -- associated with the same sampling event. */
644: UPDATE gmd_ss_variants
645: set sampling_event_id =

Line 644: UPDATE gmd_ss_variants

640: commit; */
641: /* GMD_SS_VARIANTS is updated with the sampling_event_id for the
642: -- Variant's retained samples. The variant's retained samples are
643: -- associated with the same sampling event. */
644: UPDATE gmd_ss_variants
645: set sampling_event_id =
646: x_sampling_event.sampling_event_id
647: WHERE variant_id = var_rec.variant_id;
648: p_event_spec_disp.sampling_event_id :=