APPS.GME_MAKE_TO_ORDER_PVT dependencies on MTL_RESERVATIONS

Line 74: l_rsv_row_rec MTL_RESERVATIONS%ROWTYPE;

70: l_in_serial_num INV_RESERVATION_GLOBAL.serial_number_tbl_type;
71: l_out_serial_num INV_RESERVATION_GLOBAL.serial_number_tbl_type;
72: l_exception_material_tbl GME_COMMON_PVT.exceptions_tab;
73: l_rsv_tbl GME_COMMON_PVT.reservations_tab;
74: l_rsv_row_rec MTL_RESERVATIONS%ROWTYPE;
75: l_in_assignments_rec GME_MTO_RULE_ASSIGNMENTS%ROWTYPE;
76: l_mto_rules_rec GME_MTO_RULES%ROWTYPE;
77: l_mto_assignments_rec GME_MTO_RULE_ASSIGNMENTS%ROWTYPE;
78:

Line 129: FROM mtl_reservations mr

125: l_is_serial_control BOOLEAN := FALSE;
126:
127: CURSOR cur_inv_reservations (p_line_id IN NUMBER) IS
128: SELECT mr.*
129: FROM mtl_reservations mr
130: WHERE demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
131: AND supply_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_inv
132: AND demand_source_line_id = p_line_id
133: ORDER BY mr.reservation_id;

Line 137: FROM mtl_reservations mr

133: ORDER BY mr.reservation_id;
134:
135: CURSOR cur_prod_reservations (p_line_id IN NUMBER) IS
136: SELECT count(1)
137: FROM mtl_reservations mr
138: WHERE demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
139: AND supply_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_wip
140: AND demand_source_line_id = p_line_id
141: ORDER BY mr.reservation_id;

Line 394: FROM mtl_reservations mr

390:
391: begin
392: SELECT sum(mr.primary_reservation_quantity),primary_uom_code
393: into l_total_primary_rsv_qty, l_primary_uom_code
394: FROM mtl_reservations mr
395: WHERE demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
396: AND supply_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_inv
397: AND demand_source_line_id = l_so_line_rec.line_id
398: GROUP BY mr.primary_uom_code;