APPS.INV_TRANSFER_ORDER_PVT dependencies on MTL_RESERVATIONS

Line 1122: l_mtl_reservations inv_reservation_global.mtl_reservation_tbl_type;

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

Line 2272: FROM mtl_reservations

2268: -- bug 2115082
2269: -- should only delete reservations for supply type inventory
2270: CURSOR unstaged_reservations_csr IS
2271: SELECT reservation_id
2272: FROM mtl_reservations
2273: WHERE NVL(staged_flag, 'N') = 'N'
2274: AND supply_source_type_id = 13
2275: AND demand_source_type_id IN (2, 8)
2276: AND demand_source_line_id = p_source_line_id

Line 2325: FROM mtl_system_items msi, mtl_Reservations mtr

2321: SELECT 1
2322: INTO l_ato_item
2323: FROM dual
2324: WHERE EXISTS (SELECT msi.inventory_item_id
2325: FROM mtl_system_items msi, mtl_Reservations mtr
2326: WHERE msi.inventory_item_id = mtr.inventory_item_id
2327: AND msi.organization_id = mtr.organization_id
2328: AND bom_item_type = 4
2329: AND replenish_to_order_flag = 'Y'

Line 2596: FROM mtl_reservations

2592: CURSOR reservations_csr IS
2593: SELECT reservation_id
2594: , primary_reservation_quantity
2595: , detailed_quantity
2596: FROM mtl_reservations
2597: WHERE demand_source_line_id = l_trolin_rec.txn_source_line_id
2598: AND NVL(detailed_quantity, 0) > 0
2599: AND NVL(staged_flag, 'N') = 'N'
2600: AND demand_source_line_detail IS NULL;

Line 2604: FROM mtl_reservations

2600: AND demand_source_line_detail IS NULL;
2601:
2602: CURSOR unstaged_reservations_csr IS
2603: SELECT reservation_id
2604: FROM mtl_reservations
2605: WHERE NVL(staged_flag, 'N') = 'N'
2606: AND demand_source_line_id = l_trolin_rec.txn_source_line_id
2607: AND demand_source_line_detail IS NULL;
2608:

Line 3598: UPDATE mtl_reservations

3594: DEBUG('serial count with updated null reservation_id = ' || l_serial_count, 'Finalize_Pick_Confirm');
3595: END IF;
3596:
3597: IF (l_serial_count > 0) THEN
3598: UPDATE mtl_reservations
3599: SET serial_reservation_quantity = serial_reservation_quantity - l_serial_count
3600: WHERE reservation_id = l_mtl_reservation_tbl(1).reservation_id;
3601: END IF;
3602:

Line 3631: UPDATE mtl_reservations

3627: DEBUG('serial count with updated null reservation_id = ' || l_serial_count, 'Finalize_Pick_Confirm');
3628: END IF;
3629:
3630: IF (l_serial_count > 0) THEN
3631: UPDATE mtl_reservations
3632: SET serial_reservation_quantity = serial_reservation_quantity - l_serial_count
3633: WHERE reservation_id = l_mtl_reservation_tbl(1).reservation_id;
3634: END IF;
3635: END IF;