DBA Data[Home] [Help]

APPS.MTL_RESERVATIONS_PKG dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 1291: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP

1287: IF (x_to_reservation_id IS NULL) THEN
1288: -- bug 1809218
1289: -- when deleting a reservation, make sure we delete the pointer
1290: -- to the reservation on the MMTT record.
1291: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP
1292: SET reservation_id = NULL
1293: WHERE reservation_id = x_reservation_id;
1294: ELSE
1295: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP

Line 1295: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP

1291: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP
1292: SET reservation_id = NULL
1293: WHERE reservation_id = x_reservation_id;
1294: ELSE
1295: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP
1296: SET reservation_id = x_to_reservation_id
1297: WHERE reservation_id = x_reservation_id;
1298: END IF;
1299: