APPS.GMD_COA_DATA_OM dependencies on GMD_QC_TESTS

Line 127: gmd_qc_tests_b gt

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
130: and gsb.spec_id = gst.spec_id
131: and gst.test_id = gt.test_id

Line 290: gmd_qc_tests_b gt,

286: gst.text_code spec_text_code,
287: gr.text_code rslt_text_code
288: from gmd_samples gs,
289: gmd_results gr,
290: gmd_qc_tests_b gt,
291: gmd_spec_results gsr,
292: gmd_spec_tests_b gst ,
293: gmd_sampling_events gse,
294: gmd_event_spec_disp ges,

Line 342: gmd_qc_tests_b gt,

338: gst.text_code spec_text_code,
339: gr.text_code rslt_text_code
340: from gmd_samples gs,
341: gmd_results gr,
342: gmd_qc_tests_b gt,
343: gmd_spec_results gsr,
344: gmd_spec_tests_b gst ,
345: gmd_sampling_events gse,
346: gmd_event_spec_disp ges,

Line 389: c_assay_code gmd_qc_tests_b.TEST_CODE%TYPE)

385:
386: CURSOR get_cust_spec (c_item_id ic_item_mst.item_id%TYPE,
387: c_cust_id hz_cust_accounts.cust_account_id%TYPE,
388: c_orgn_code gmd_customer_spec_vrs.ORGN_CODE%TYPE,
389: c_assay_code gmd_qc_tests_b.TEST_CODE%TYPE)
390: IS
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,

Line 398: gmd_qc_tests_b gt

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
400: and gsb.spec_id = gst.spec_id
401: and gst.test_id = gt.test_id
402: and nvl(gst.print_result_ind, 'N') = 'Y'

Line 411: c_assay_code gmd_qc_tests_b.TEST_CODE%TYPE)

407: and gsb.delete_mark= 0;
408:
409: CURSOR get_global_cust_spec (c_item_id ic_item_mst.item_id%TYPE,
410: c_cust_id hz_cust_accounts.cust_account_id%TYPE,
411: c_assay_code gmd_qc_tests_b.TEST_CODE%TYPE)
412: IS
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,

Line 420: gmd_qc_tests_b gt

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
422: and gsb.spec_id = gst.spec_id
423: and gst.test_id = gt.test_id
424: and nvl(gst.print_result_ind, 'N') = 'Y'

Line 432: CURSOR get_assay_info (c_assay_code gmd_qc_tests_b.TEST_CODE%TYPE)

428: and gcs.orgn_code is NULL
429: and gsb.delete_mark= 0;
430:
431:
432: CURSOR get_assay_info (c_assay_code gmd_qc_tests_b.TEST_CODE%TYPE)
433: IS
434: select gt.test_desc assay_desc
435: from gmd_qc_tests gt
436: where gt.test_code = c_assay_code

Line 435: from gmd_qc_tests gt

431:
432: CURSOR get_assay_info (c_assay_code gmd_qc_tests_b.TEST_CODE%TYPE)
433: IS
434: select gt.test_desc assay_desc
435: from gmd_qc_tests gt
436: where gt.test_code = c_assay_code
437: and gt.delete_mark = 0;
438:
439: tbl_ndx BINARY_INTEGER := 0;