APPS.GMD_COA_DATA_OM_NEW dependencies on GMD_SPEC_RESULTS

Line 365: gmd_spec_results sr,

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
369: and nvl(sr.evaluation_ind,'N') in ('0A','1V','2R','N') -- srakrish bug 5747932: To fetch results for non validated tests.

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

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
521: (p_report_type = 'COA' and nvl(s.print_result_ind,'N') ='Y'))

Line 953: GMD_SPEC_RESULTS sp

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