DBA Data[Home] [Help]

APPS.INV_STAGED_RESERVATION_UTIL dependencies on MTL_RESERVATIONS

Line 21: from mtl_reservations

17: SAVEPOINT query_stage_sa;
18:
19: select nvl(staged_flag,'N')
20: into x_staged_flag
21: from mtl_reservations
22: where reservation_id = p_reservation_id;
23:
24: EXCEPTION
25: WHEN fnd_api.g_exc_error THEN

Line 83: update mtl_reservations

79: END IF;
80:
81: SAVEPOINT update_stage_sa;
82:
83: update mtl_reservations
84: set staged_flag = p_staged_flag
85: ,ship_ready_flag = l_ship_ready_flag -- Bug #2816312
86: where reservation_id = p_reservation_id;
87: