APPS.GME_MAKE_TO_ORDER_PVT dependencies on MTL_RESERVATIONS

Line 84: l_rsv_row_rec MTL_RESERVATIONS%ROWTYPE;

80: l_in_serial_num INV_RESERVATION_GLOBAL.serial_number_tbl_type;
81: l_out_serial_num INV_RESERVATION_GLOBAL.serial_number_tbl_type;
82: l_exception_material_tbl GME_COMMON_PVT.exceptions_tab;
83: l_rsv_tbl GME_COMMON_PVT.reservations_tab;
84: l_rsv_row_rec MTL_RESERVATIONS%ROWTYPE;
85: l_in_assignments_rec GME_MTO_RULE_ASSIGNMENTS%ROWTYPE;
86: l_mto_rules_rec GME_MTO_RULES%ROWTYPE;
87: l_mto_assignments_rec GME_MTO_RULE_ASSIGNMENTS%ROWTYPE;
88:

Line 144: FROM mtl_reservations mr

140: l_is_serial_control BOOLEAN := FALSE;
141:
142: CURSOR cur_inv_reservations (p_line_id IN NUMBER) IS
143: SELECT mr.*
144: FROM mtl_reservations mr
145: WHERE demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
146: AND supply_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_inv
147: AND demand_source_line_id = p_line_id
148: ORDER BY mr.reservation_id;

Line 152: FROM mtl_reservations mr

148: ORDER BY mr.reservation_id;
149:
150: CURSOR cur_prod_reservations (p_line_id IN NUMBER) IS
151: SELECT count(1)
152: FROM mtl_reservations mr
153: WHERE demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
154: AND supply_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_wip
155: AND demand_source_line_id = p_line_id
156: ORDER BY mr.reservation_id;

Line 431: FROM mtl_reservations mr

427:
428: begin
429: SELECT sum(mr.primary_reservation_quantity),primary_uom_code
430: into l_total_primary_rsv_qty, l_primary_uom_code
431: FROM mtl_reservations mr
432: WHERE demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
433: AND supply_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_inv
434: AND demand_source_line_id = l_so_line_rec.line_id
435: GROUP BY mr.primary_uom_code;