eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_QC_MIGB12 dependencies on GME_MATERIAL_DETAILS

Line 69: FROM gme_material_details

65: ==========================================*/
66:
67: CURSOR get_line_info IS
68: SELECT line_no, line_type
69: FROM gme_material_details
70: WHERE material_detail_id = p_old_mat_det_id;
71:
72: l_line_no gme_material_details.line_no%TYPE;
73: l_line_type gme_material_details.line_type%TYPE;

Line 72: l_line_no gme_material_details.line_no%TYPE;

68: SELECT line_no, line_type
69: FROM gme_material_details
70: WHERE material_detail_id = p_old_mat_det_id;
71:
72: l_line_no gme_material_details.line_no%TYPE;
73: l_line_type gme_material_details.line_type%TYPE;
74:
75: /*==========================================
76: Cursor to new material detail id.

Line 73: l_line_type gme_material_details.line_type%TYPE;

69: FROM gme_material_details
70: WHERE material_detail_id = p_old_mat_det_id;
71:
72: l_line_no gme_material_details.line_no%TYPE;
73: l_line_type gme_material_details.line_type%TYPE;
74:
75: /*==========================================
76: Cursor to new material detail id.
77: ==========================================*/

Line 81: FROM gme_material_details

77: ==========================================*/
78:
79: CURSOR get_matl_det IS
80: SELECT material_detail_id
81: FROM gme_material_details
82: WHERE batch_id = p_new_batch_id
83: AND line_no = l_line_no
84: AND line_type = l_line_type;
85: