DBA Data[Home] [Help]

APPS.GMD_SPEC_MATCH_GRP dependencies on GMD_SAMPLE_SPEC_DISP

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

1253: SELECT nvl(gs.lot_number,-1), gs.sample_id,gr.test_id,gr.result_value_num,gr.result_value_char -- 9744927 added nvl(gs.lot_number,-1)
1254: FROM GMD_SAMPLES gs , GMD_RESULTS gr
1255: WHERE gs.sample_id = gr.sample_id
1256: AND gs.delete_mark = 0
1257: AND gs.sample_id IN ( SELECT ssd.sample_id FROM gmd_sample_spec_disp ssd
1258: WHERE ssd.sample_id = gs.sample_id
1259: AND ssd.disposition IN ('3C','4A','5AV','6RJ') )
1260: AND gs.inventory_item_id = l_inventory_item_id
1261: AND gs.organization_id = l_organization_id