DBA Data[Home] [Help]

APPS.WMS_XDOCK_EXCEPTION dependencies on MTL_RESERVATIONS

Line 79: FROM mtl_reservations

75: , demand_source_line_detail
76: , supply_receipt_date
77: , exception_code
78: , demand_ship_date
79: FROM mtl_reservations
80: WHERE Nvl(crossdock_flag,'N') = 'Y'
81: AND Nvl(staged_flag, 'N') = 'N' --???
82: AND supply_source_type_id <> 13 --??? not inventory
83: AND (supply_receipt_date <= l_now + p_look_ahead_time

Line 297: UPDATE mtl_reservations

293:
294: IF (l_update_flag = 'Y') THEN
295:
296: BEGIN
297: UPDATE mtl_reservations
298: SET exception_code = l_exception_code
299: , supply_receipt_date = Decode(l_new_reservation.supply_receipt_date,
300: fnd_api.g_miss_date,
301: supply_receipt_date,