[Home] [Help]
323: r.result_date,
324: r.text_code
325: from gmd_results r,
326: gmd_spec_results sr,
327: gmd_event_spec_disp ges
328: where r.sample_id = p_sample_id
329: and r.result_id = sr.result_id
330: and nvl(sr.evaluation_ind,'N') in ('0A','1V','2R','N') -- srakrish bug 5747932: To fetch results for non validated tests.
331: and sr.event_spec_disp_id = ges.event_spec_disp_id
396: r.non_validated_result,
397: r.standard_deviation , ges.spec_id
398: from gmd_composite_results r,
399: gmd_composite_spec_disp sd,
400: gmd_event_spec_disp ges
401: where r.composite_spec_disp_id =sd.composite_spec_disp_id
402: and sd.event_spec_disp_id = p_event_spec_disp_id
403: and sd.event_spec_disp_id = ges.event_spec_disp_id
404: and nvl(ges.spec_used_for_lot_attrib_ind,'N') = 'Y'
771: select nvl(a.SAMPLE_ACTIVE_CNT,0) sample_active_cnt,
772: b.event_spec_disp_id,
773: b.sampling_event_id
774: from gmd_sampling_events
775: a,gmd_event_spec_disp b
776: where b.spec_id =p_spec_id
777: and (a.lot_number = p_lot_number or p_lot_number is null)
778: and b.disposition in ('4A','5AV','5RJ')
779: and b.spec_used_for_lot_attrib_ind ='Y'
884: gr.test_id,
885: gr.result_value_num,
886: gr.result_value_char,'SAMPLE'
887: FROM GMD_SAMPLING_EVENTS gs ,
888: GMD_EVENT_SPEC_DISP ges,
889: GMD_RESULTS gr,
890: GMD_SPEC_RESULTS sp
891: WHERE
892: gs.inventory_item_id = l_inventory_item_id
909: gr.test_id,
910: gr.mean result_value_num,
911: gr.mode_char result_value_char,'EVENT_SPEC_DISP'
912: FROM GMD_SAMPLING_EVENTS gs ,
913: GMD_EVENT_SPEC_DISP sd,
914: GMD_COMPOSITE_RESULTS gr,
915: GMD_COMPOSITE_SPEC_DISP ges
916: WHERE
917: gs.inventory_item_id = l_inventory_item_id
1157:
1158: CURSOR c_samples IS
1159: select a.organization_id, c.organization_code, a.sample_no
1160: from gmd_samples a,
1161: gmd_event_spec_disp b,
1162: mtl_parameters c
1163: where a.sampling_event_id = b.sampling_event_id
1164: and b.event_spec_disp_id = p_event_spec_disp_id
1165: and a.organization_id = c.organization_id;