APPS.GMD_SPEC_MATCH_MIG_GRP dependencies on GMD_SAMPLES

Line 1303: FROM GMD_SAMPLES gs , GMD_RESULTS gr

1299: AND gst.optional_ind is NULL ;
1300:
1301: CURSOR cr_get_sample_for_lot IS
1302: SELECT gs.sample_id,gr.test_id,gr.result_value_num,gr.result_value_char
1303: FROM GMD_SAMPLES gs , GMD_RESULTS gr
1304: WHERE gs.sample_id = gr.sample_id
1305: AND gs.delete_mark = 0
1306: AND gs.sample_id IN ( SELECT ssd.sample_id FROM gmd_sample_spec_disp ssd
1307: WHERE ssd.sample_id = gs.sample_id