APPS.GMD_COA_DATA_NEW dependencies on GMD_RESULTS

Line 60: qc_result_id gmd_results.result_id%TYPE,

56: );
57:
58: TYPE t_coa_dtl_rec IS RECORD
59: (gmd_coa_id BINARY_INTEGER,
60: qc_result_id gmd_results.result_id%TYPE,
61: result_date gmd_results.result_date%TYPE,
62: qc_spec_id gmd_specifications_b.spec_id%TYPE,
63: assay_code gmd_qc_tests_b.test_code%TYPE,
64: assay_desc gmd_qc_tests.test_desc%TYPE,

Line 61: result_date gmd_results.result_date%TYPE,

57:
58: TYPE t_coa_dtl_rec IS RECORD
59: (gmd_coa_id BINARY_INTEGER,
60: qc_result_id gmd_results.result_id%TYPE,
61: result_date gmd_results.result_date%TYPE,
62: qc_spec_id gmd_specifications_b.spec_id%TYPE,
63: assay_code gmd_qc_tests_b.test_code%TYPE,
64: assay_desc gmd_qc_tests.test_desc%TYPE,
65: result gmd_results.result_value_char%TYPE,

Line 65: result gmd_results.result_value_char%TYPE,

61: result_date gmd_results.result_date%TYPE,
62: qc_spec_id gmd_specifications_b.spec_id%TYPE,
63: assay_code gmd_qc_tests_b.test_code%TYPE,
64: assay_desc gmd_qc_tests.test_desc%TYPE,
65: result gmd_results.result_value_char%TYPE,
66: specification gmd_spec_tests_b.target_value_char%TYPE,
67: min_spec gmd_spec_tests_b.min_value_num%TYPE,
68: max_spec gmd_spec_tests_b.max_value_num%TYPE,
69: uom gmd_spec_tests_b.test_uom%TYPE,

Line 71: rslt_text_code gmd_results.text_code%TYPE,

67: min_spec gmd_spec_tests_b.min_value_num%TYPE,
68: max_spec gmd_spec_tests_b.max_value_num%TYPE,
69: uom gmd_spec_tests_b.test_uom%TYPE,
70: spec_text_code gmd_specifications_b.text_code%TYPE,
71: rslt_text_code gmd_results.text_code%TYPE,
72: coa_sort_order NUMBER
73: );
74:
75: TYPE t_coa_text_rec IS RECORD