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 1273: FROM mtl_reservations mr

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

Line 1301: FROM mtl_reservations mr

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