APPS.GMD_COA_DATA_OM_NEW dependencies on GMD_RESULTS

Line 325: from gmd_results r,

321: r.result_value_char,
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

Line 473: -- gmd_results r, --BUG#3588346

469: FROM gmd_spec_tests s,
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

Line 889: GMD_RESULTS gr,

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

Line 1088: l_in_spec := GMD_RESULTS_GRP.rslt_is_in_spec(

1084:
1085: WHILE l_spec_test_counter IS NOT NULL
1086: LOOP
1087: PrintLn('In WHILE l_spec_test_counter LOOP');
1088: l_in_spec := GMD_RESULTS_GRP.rslt_is_in_spec(
1089: p_spec_id => p_spec_id
1090: , p_test_id => spec_test_list(l_spec_test_counter)
1091: , p_rslt_value_num => result_test_list(l_spec_test_counter).result_value_num
1092: , p_rslt_value_char => result_test_list(l_spec_test_counter).result_value_char ) ;