APPS.GMD_COA_DATA_OM dependencies on GMD_SPECIFICATIONS_B

Line 125: gmd_specifications_b gsb,

121: specification,
122: gt.test_unit uom,
123: gst.text_code spec_text_code
124: from
125: gmd_specifications_b gsb,
126: gmd_spec_tests_b gst,
127: gmd_qc_tests_b gt
128: where
129: gsb.spec_id = c_spec_id

Line 295: gmd_specifications_b gsb,

291: gmd_spec_results gsr,
292: gmd_spec_tests_b gst ,
293: gmd_sampling_events gse,
294: gmd_event_spec_disp ges,
295: gmd_specifications_b gsb,
296: gmd_sample_spec_disp gss
297: where gs.sample_id = gr.sample_id
298: and gse.sampling_event_id = gs.sampling_event_id
299: and gse.sampling_event_id = ges.sampling_event_id

Line 347: gmd_specifications_b gsb,

343: gmd_spec_results gsr,
344: gmd_spec_tests_b gst ,
345: gmd_sampling_events gse,
346: gmd_event_spec_disp ges,
347: gmd_specifications_b gsb,
348: gmd_sample_spec_disp gss
349: where gs.sample_id = gr.sample_id
350: and gse.sampling_event_id = gs.sampling_event_id
351: and gse.sampling_event_id = ges.sampling_event_id

Line 395: from gmd_specifications_b gsb,

391: select gsb.spec_id qc_spec_id,
392: decode(gst.target_value_char, null, to_char(gst.target_value_num),gst.target_value_char)
393: specification,
394: gcs.text_code spec_text_code
395: from gmd_specifications_b gsb,
396: gmd_customer_spec_vrs gcs,
397: gmd_spec_tests_b gst,
398: gmd_qc_tests_b gt
399: where gsb.spec_id = gcs.spec_id

Line 417: from gmd_specifications_b gsb,

413: select gsb.spec_id qc_spec_id,
414: decode(gst.target_value_char, null, to_char(gst.target_value_num),gst.target_value_char)
415: specification,
416: gcs.text_code spec_text_code
417: from gmd_specifications_b gsb,
418: gmd_customer_spec_vrs gcs,
419: gmd_spec_tests_b gst,
420: gmd_qc_tests_b gt
421: where gsb.spec_id = gcs.spec_id