APPS.GME_RESCHEDULE_STEP_PVT dependencies on GME_MATERIAL_DETAILS

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

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

Line 112: FROM gme_material_details

108:
109: CURSOR cur_get_material (v_batch_id NUMBER)
110: IS
111: SELECT material_detail_id, line_type
112: FROM gme_material_details
113: WHERE batch_id = v_batch_id;
114:
115: -- Bug 11925400 - Add step status check to the where clause.
116: CURSOR cur_get_prec_steps (v_batch_id NUMBER, v_batchstep_id NUMBER)

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

1081: l_batch_header_rec gme_batch_header%ROWTYPE;
1082: l_in_batch_header_rec gme_batch_header%ROWTYPE;
1083: x_batch_header_rec gme_batch_header%ROWTYPE;
1084:
1085: TYPE l_line_type_tbl_typ IS TABLE OF gme_material_details.line_type%TYPE
1086: INDEX BY BINARY_INTEGER;
1087:
1088: l_line_type_tbl l_line_type_tbl_typ;
1089: l_material_date DATE;

Line 1105: FROM gme_material_details det

1101:
1102: CURSOR cur_get_material (v_batch_id NUMBER, v_batchstep_id NUMBER)
1103: IS
1104: SELECT material_detail_id, line_type
1105: FROM gme_material_details det
1106: WHERE batch_id = v_batch_id
1107: AND release_type IN (1, 2, 3)
1108: AND EXISTS (
1109: SELECT 1