APPS.GME_RESCHEDULE_STEP_PVT dependencies on GME_MATERIAL_DETAILS

Line 55: TYPE l_line_type_tbl_typ IS TABLE OF gme_material_details.line_type%TYPE

51: l_loop_count_get_material NUMBER;
52: --Bug#5606089
53: l_batch_step2_rec gme_batch_steps%ROWTYPE;
54: x_batch_step2_rec gme_batch_steps%ROWTYPE;
55: TYPE l_line_type_tbl_typ IS TABLE OF gme_material_details.line_type%TYPE
56: INDEX BY BINARY_INTEGER;
57:
58: l_line_type_tbl l_line_type_tbl_typ;
59: l_material_date DATE;

Line 110: FROM gme_material_details

106:
107: CURSOR cur_get_material (v_batch_id NUMBER)
108: IS
109: SELECT material_detail_id, line_type
110: FROM gme_material_details
111: WHERE batch_id = v_batch_id;
112:
113: CURSOR cur_get_prec_steps (v_batch_id NUMBER, v_batchstep_id NUMBER)
114: IS

Line 1079: TYPE l_line_type_tbl_typ IS TABLE OF gme_material_details.line_type%TYPE

1075: l_batch_header_rec gme_batch_header%ROWTYPE;
1076: l_in_batch_header_rec gme_batch_header%ROWTYPE;
1077: x_batch_header_rec gme_batch_header%ROWTYPE;
1078:
1079: TYPE l_line_type_tbl_typ IS TABLE OF gme_material_details.line_type%TYPE
1080: INDEX BY BINARY_INTEGER;
1081:
1082: l_line_type_tbl l_line_type_tbl_typ;
1083: l_material_date DATE;

Line 1099: FROM gme_material_details det

1095:
1096: CURSOR cur_get_material (v_batch_id NUMBER, v_batchstep_id NUMBER)
1097: IS
1098: SELECT material_detail_id, line_type
1099: FROM gme_material_details det
1100: WHERE batch_id = v_batch_id
1101: AND release_type IN (1, 2, 3)
1102: AND EXISTS (
1103: SELECT 1