APPS.GME_MOBILE_RSRV dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 142: FROM mtl_material_transactions_temp

138: AND mr.locator_id = loc.inventory_location_id(+)
139: AND NVL(mr.lot_number, '-1') = NVL(p_lot_number, '-1')
140: AND mr.reservation_id <> NVL(p_exclude_res_id, 0)
141: AND NOT EXISTS (SELECT 1
142: FROM mtl_material_transactions_temp
143: WHERE reservation_id = mr.reservation_id);
144:
145: EXCEPTION
146: WHEN OTHERS THEN

Line 225: FROM mtl_material_transactions_temp

221: AND mr.subinventory_code = loc.subinventory_code(+)
222: AND mr.locator_id = loc.inventory_location_id(+)
223: AND (p_lot_number IS NULL OR (mr.lot_number = p_lot_number))
224: AND NOT EXISTS (SELECT 1
225: FROM mtl_material_transactions_temp
226: WHERE reservation_id = mr.reservation_id)
227: ORDER BY mr.requirement_date;
228:
229: EXCEPTION

Line 302: FROM mtl_material_transactions_temp

298: AND mr.subinventory_code = loc.subinventory_code(+)
299: AND mr.locator_id = loc.inventory_location_id(+)
300: AND (p_lotcontrol = 0 OR (p_lotcontrol = 1 AND mr.lot_number IS NOT NULL))
301: AND NOT EXISTS (SELECT 1
302: FROM mtl_material_transactions_temp
303: WHERE reservation_id = mr.reservation_id)
304: ORDER BY mr.requirement_date;
305:
306: EXCEPTION