APPS.INV_TRANSFER_ORDER_PVT dependencies on MTL_RESERVATIONS

Line 1125: l_mtl_reservations inv_reservation_global.mtl_reservation_tbl_type;

1121: l_old_trolin_rec inv_move_order_pub.trolin_rec_type;
1122: l_old_trolin_tbl inv_move_order_pub.trolin_tbl_type;
1123: l_troldt_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;
1124: l_quantity_cancel NUMBER;
1125: l_mtl_reservations inv_reservation_global.mtl_reservation_tbl_type;
1126: l_mtl_reservation_count NUMBER;
1127: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
1128: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1129: l_msg_count NUMBER;

Line 2285: FROM mtl_reservations

2281: -- bug 2115082
2282: -- should only delete reservations for supply type inventory
2283: CURSOR unstaged_reservations_csr IS
2284: SELECT reservation_id
2285: FROM mtl_reservations
2286: WHERE NVL(staged_flag, 'N') = 'N'
2287: AND supply_source_type_id = 13
2288: AND demand_source_type_id IN (2, 8)
2289: AND demand_source_line_id = p_source_line_id

Line 2338: FROM mtl_system_items msi, mtl_Reservations mtr

2334: SELECT 1
2335: INTO l_ato_item
2336: FROM dual
2337: WHERE EXISTS (SELECT msi.inventory_item_id
2338: FROM mtl_system_items msi, mtl_Reservations mtr
2339: WHERE msi.inventory_item_id = mtr.inventory_item_id
2340: AND msi.organization_id = mtr.organization_id
2341: AND bom_item_type = 4
2342: AND replenish_to_order_flag = 'Y'

Line 2620: FROM mtl_reservations

2616: CURSOR reservations_csr IS
2617: SELECT reservation_id
2618: , primary_reservation_quantity
2619: , detailed_quantity
2620: FROM mtl_reservations
2621: WHERE demand_source_line_id = l_trolin_rec.txn_source_line_id
2622: AND NVL(detailed_quantity, 0) > 0
2623: AND NVL(staged_flag, 'N') = 'N'
2624: AND demand_source_line_detail IS NULL;

Line 2628: FROM mtl_reservations

2624: AND demand_source_line_detail IS NULL;
2625:
2626: CURSOR unstaged_reservations_csr IS
2627: SELECT reservation_id
2628: FROM mtl_reservations
2629: WHERE NVL(staged_flag, 'N') = 'N'
2630: AND demand_source_line_id = l_trolin_rec.txn_source_line_id
2631: AND demand_source_line_detail IS NULL;
2632:

Line 3842: UPDATE mtl_reservations

3838: DEBUG('serial count with updated null reservation_id = ' || l_serial_count, 'Finalize_Pick_Confirm');
3839: END IF;
3840:
3841: IF (l_serial_count > 0) THEN
3842: UPDATE mtl_reservations
3843: SET serial_reservation_quantity = serial_reservation_quantity - l_serial_count
3844: WHERE reservation_id = l_mtl_reservation_tbl(1).reservation_id;
3845:
3846: IF (l_debug = 1) THEN --Bug# 9774870

Line 3881: UPDATE mtl_reservations

3877: DEBUG('serial count with updated null reservation_id = ' || l_serial_count, 'Finalize_Pick_Confirm');
3878: END IF;
3879:
3880: IF (l_serial_count > 0) THEN
3881: UPDATE mtl_reservations
3882: SET serial_reservation_quantity = serial_reservation_quantity - l_serial_count
3883: WHERE reservation_id = l_mtl_reservation_tbl(1).reservation_id;
3884:
3885: IF (l_debug = 1) THEN --Bug# 9774870