APPS.INV_MO_CANCEL_PVT dependencies on MTL_RESERVATIONS

Line 108: FROM mtl_reservations mr

104: FOR UPDATE NOWAIT;
105:
106: CURSOR c_reservations IS
107: SELECT mr.reservation_id
108: FROM mtl_reservations mr
109: WHERE mr.demand_source_type_id IN (2, 8)
110: AND nvl(mr.staged_flag,'N') <> 'Y'
111: AND demand_source_line_detail IS NULL
112: AND mr.demand_source_line_id = l_txn_source_line_id

Line 138: FROM mtl_reservations

134: -- INVCONV - Added Qty2
135: CURSOR c_primary_rsv_qty IS
136: SELECT sum(primary_reservation_quantity),
137: sum(secondary_reservation_quantity)
138: FROM mtl_reservations
139: WHERE reservation_id IN (SELECT DISTINCT reservation_id
140: FROM mtl_material_transactions_temp
141: WHERE move_order_line_id = p_line_id);
142:

Line 165: FROM mtl_reservations mr

161: CURSOR c_xdock_rsv
162: ( p_wdd_id IN NUMBER
163: ) IS
164: SELECT mr.reservation_id
165: FROM mtl_reservations mr
166: WHERE mr.demand_source_line_detail = p_wdd_id
167: AND mr.demand_source_type_id IN (2,8)
168: AND NVL(mr.crossdock_flag,'N') = 'Y'
169: FOR UPDATE NOWAIT;

Line 1275: FROM mtl_reservations mr

1271: AND released_status = 'S';
1272:
1273: CURSOR c_reservations IS
1274: SELECT mr.reservation_id
1275: FROM mtl_reservations mr
1276: WHERE mr.demand_source_type_id IN (2,8)
1277: AND NVL(mr.staged_flag,'N') <> 'Y'
1278: AND mr.demand_source_line_id = l_txn_source_line_id
1279: AND mr.demand_source_line_detail IS NULL

Line 1303: FROM mtl_reservations mr

1299: CURSOR c_xdock_rsv
1300: ( p_wdd_id IN NUMBER
1301: ) IS
1302: SELECT mr.reservation_id
1303: FROM mtl_reservations mr
1304: WHERE mr.demand_source_line_detail = p_wdd_id
1305: AND mr.demand_source_type_id IN (2,8)
1306: AND NVL(mr.crossdock_flag,'N') = 'Y'
1307: FOR UPDATE NOWAIT;