APPS.GMD_COA_DATA_OM_NEW dependencies on GMD_SPEC_RESULTS

Line 326: gmd_spec_results sr,

322: r.result_value_num,
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.

Line 474: -- gmd_spec_results sr --BUG#3588346

470: gmd_qc_tests t,
471: gmd_test_methods_b m
472: --Bug 3785184 backing out fix 3588346
473: -- gmd_results r, --BUG#3588346
474: -- gmd_spec_results sr --BUG#3588346
475: WHERE s.test_id= t.test_id
476: AND s.spec_id= p_spec_id
477: AND ((p_report_type = 'COC' and nvl(s.print_spec_ind,'N') ='Y') OR
478: (p_report_type = 'COA' and nvl(s.print_result_ind,'N') ='Y'))

Line 890: GMD_SPEC_RESULTS sp

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
893: AND (gs.revision = l_revision OR gs.revision IS NULL )
894: AND (gs.lot_number = l_lot_number OR gs.lot_number IS NULL)