APPS.GMD_SPEC_MATCH_MIG_GRP dependencies on GMD_SAMPLE_SPEC_DISP

Line 1306: AND gs.sample_id IN ( SELECT ssd.sample_id FROM gmd_sample_spec_disp ssd

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
1308: AND ssd.disposition IN ('3C','4A','5AV','6RJ') )
1309: AND gs.item_id = l_item_id
1310: AND (gs.lot_no = l_lot_no OR gs.lot_no IS NULL)