APPS.GMD_COA_DATA_OM_NEW dependencies on GMD_RESULTS

Line 364: from gmd_results r,

360: r.result_value_char,
361: r.result_value_num,
362: r.result_date,
363: r.text_code
364: from gmd_results r,
365: gmd_spec_results sr,
366: gmd_event_spec_disp ges
367: where r.sample_id = p_sample_id
368: and r.result_id = sr.result_id

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

512: FROM gmd_spec_tests s,
513: gmd_qc_tests t,
514: gmd_test_methods_b m
515: --Bug 3785184 backing out fix 3588346
516: -- gmd_results r, --BUG#3588346
517: -- gmd_spec_results sr --BUG#3588346
518: WHERE s.test_id= t.test_id
519: AND s.spec_id= p_spec_id
520: AND ((p_report_type = 'COC' and nvl(s.print_spec_ind,'N') ='Y') OR

Line 952: GMD_RESULTS gr,

948: gr.result_value_num,
949: gr.result_value_char,'SAMPLE'
950: FROM GMD_SAMPLING_EVENTS gs ,
951: GMD_EVENT_SPEC_DISP ges,
952: GMD_RESULTS gr,
953: GMD_SPEC_RESULTS sp
954: WHERE
955: gs.inventory_item_id = l_inventory_item_id
956: AND (gs.revision = l_revision OR gs.revision IS NULL )

Line 1159: l_in_spec := GMD_RESULTS_GRP.rslt_is_in_spec(

1155:
1156: WHILE l_spec_test_counter IS NOT NULL
1157: LOOP
1158: PrintLn('In WHILE l_spec_test_counter LOOP');
1159: l_in_spec := GMD_RESULTS_GRP.rslt_is_in_spec(
1160: p_spec_id => p_spec_id
1161: , p_test_id => spec_test_list(l_spec_test_counter)
1162: , p_rslt_value_num => result_test_list(l_spec_test_counter).result_value_num
1163: , p_rslt_value_char => result_test_list(l_spec_test_counter).result_value_char ) ;