DBA Data[Home] [Help]

APPS.GMD_COA_DATA_OM dependencies on GMD_RESULTS

Line 66: qc_result_id gmd_results.result_id%TYPE,

62: );
63:
64: TYPE t_coa_dtl_rec IS RECORD
65: (gmd_coa_id BINARY_INTEGER,
66: qc_result_id gmd_results.result_id%TYPE,
67: result_date gmd_results.result_date%TYPE,
68: qc_spec_id gmd_specifications_b.spec_id%TYPE,
69: assay_code gmd_qc_tests_b.test_code%TYPE,
70: assay_desc gmd_qc_tests.test_desc%TYPE,

Line 67: result_date gmd_results.result_date%TYPE,

63:
64: TYPE t_coa_dtl_rec IS RECORD
65: (gmd_coa_id BINARY_INTEGER,
66: qc_result_id gmd_results.result_id%TYPE,
67: result_date gmd_results.result_date%TYPE,
68: qc_spec_id gmd_specifications_b.spec_id%TYPE,
69: assay_code gmd_qc_tests_b.test_code%TYPE,
70: assay_desc gmd_qc_tests.test_desc%TYPE,
71: result gmd_results.result_value_char%TYPE,

Line 71: result gmd_results.result_value_char%TYPE,

67: result_date gmd_results.result_date%TYPE,
68: qc_spec_id gmd_specifications_b.spec_id%TYPE,
69: assay_code gmd_qc_tests_b.test_code%TYPE,
70: assay_desc gmd_qc_tests.test_desc%TYPE,
71: result gmd_results.result_value_char%TYPE,
72: specification gmd_spec_tests_b.target_value_char%TYPE,
73: min_spec gmd_spec_tests_b.min_value_num%TYPE,
74: max_spec gmd_spec_tests_b.max_value_num%TYPE,
75: uom gmd_spec_tests_b.test_uom%TYPE,

Line 77: rslt_text_code gmd_results.text_code%TYPE,

73: min_spec gmd_spec_tests_b.min_value_num%TYPE,
74: max_spec gmd_spec_tests_b.max_value_num%TYPE,
75: uom gmd_spec_tests_b.test_uom%TYPE,
76: spec_text_code gmd_specifications_b.text_code%TYPE,
77: rslt_text_code gmd_results.text_code%TYPE,
78: coa_sort_order NUMBER
79: );
80:
81: TYPE t_coa_text_rec IS RECORD