DBA Data[Home] [Help]

APPS.GMD_COA_DATA_OM_NEW dependencies on GMD_RESULTS

Line 60: result_id gmd_results.result_id%TYPE,

56: );
57:
58: TYPE t_coa_dtl_rec IS RECORD
59: (gmd_coa_id BINARY_INTEGER,
60: result_id gmd_results.result_id%TYPE,
61: result_date gmd_results.result_date%TYPE,
62: spec_id gmd_specifications_b.spec_id%TYPE,
63: test_id gmd_qc_tests_b.test_id%TYPE,
64: test_code gmd_qc_tests_b.test_code%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: result_id gmd_results.result_id%TYPE,
61: result_date gmd_results.result_date%TYPE,
62: spec_id gmd_specifications_b.spec_id%TYPE,
63: test_id gmd_qc_tests_b.test_id%TYPE,
64: test_code gmd_qc_tests_b.test_code%TYPE,
65: test_method varchar2(80),

Line 68: result gmd_results.result_value_char%TYPE,

64: test_code gmd_qc_tests_b.test_code%TYPE,
65: test_method varchar2(80),
66: test_type gmd_qc_tests_b.test_type%TYPE,
67: test_display gmd_qc_tests.test_desc%TYPE,
68: result gmd_results.result_value_char%TYPE,
69: specification varchar2(200),
70: min_spec varchar2(240),
71: max_spec varchar2(240),
72: mean gmd_composite_results.mean%TYPE,

Line 76: rslt_text_code gmd_results.text_code%TYPE,

72: mean gmd_composite_results.mean%TYPE,
73: mode_char gmd_composite_results.mode_char%TYPE,
74: test_unit gmd_qc_tests_b.test_unit%TYPE,
75: spec_text_code gmd_specifications_b.text_code%TYPE,
76: rslt_text_code gmd_results.text_code%TYPE,
77: result_value_char gmd_results.result_value_char%TYPE,
78: result_value_num gmd_results.result_value_num%TYPE,
79: report_precision NUMBER,
80: coa_sort_order NUMBER

Line 77: result_value_char gmd_results.result_value_char%TYPE,

73: mode_char gmd_composite_results.mode_char%TYPE,
74: test_unit gmd_qc_tests_b.test_unit%TYPE,
75: spec_text_code gmd_specifications_b.text_code%TYPE,
76: rslt_text_code gmd_results.text_code%TYPE,
77: result_value_char gmd_results.result_value_char%TYPE,
78: result_value_num gmd_results.result_value_num%TYPE,
79: report_precision NUMBER,
80: coa_sort_order NUMBER
81: );

Line 78: result_value_num gmd_results.result_value_num%TYPE,

74: test_unit gmd_qc_tests_b.test_unit%TYPE,
75: spec_text_code gmd_specifications_b.text_code%TYPE,
76: rslt_text_code gmd_results.text_code%TYPE,
77: result_value_char gmd_results.result_value_char%TYPE,
78: result_value_num gmd_results.result_value_num%TYPE,
79: report_precision NUMBER,
80: coa_sort_order NUMBER
81: );
82: