DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on INV_CACHE

Line 605: IF inv_cache.set_item_rec(p_org_id , l_inventory_item_id) THEN

601: ** To identify lot corruption in WMS enabled orgs --bug#10415632
602: */
603: --13390994
604: --Removed the query to fetch Lot Control and got it from Cache
605: IF inv_cache.set_item_rec(p_org_id , l_inventory_item_id) THEN
606: l_lot_code := inv_cache.item_rec.lot_control_code;
607: l_serial_control_code := inv_cache.item_rec.serial_number_control_code;
608: END IF;
609: IF (l_debug = 1) THEN

Line 606: l_lot_code := inv_cache.item_rec.lot_control_code;

602: */
603: --13390994
604: --Removed the query to fetch Lot Control and got it from Cache
605: IF inv_cache.set_item_rec(p_org_id , l_inventory_item_id) THEN
606: l_lot_code := inv_cache.item_rec.lot_control_code;
607: l_serial_control_code := inv_cache.item_rec.serial_number_control_code;
608: END IF;
609: IF (l_debug = 1) THEN
610: mydebug('create_mo: Item Id : ' || l_inventory_item_id || ', Lot Control code : ' || l_lot_code||', Lot Number : '|| l_lot_number);

Line 607: l_serial_control_code := inv_cache.item_rec.serial_number_control_code;

603: --13390994
604: --Removed the query to fetch Lot Control and got it from Cache
605: IF inv_cache.set_item_rec(p_org_id , l_inventory_item_id) THEN
606: l_lot_code := inv_cache.item_rec.lot_control_code;
607: l_serial_control_code := inv_cache.item_rec.serial_number_control_code;
608: END IF;
609: IF (l_debug = 1) THEN
610: mydebug('create_mo: Item Id : ' || l_inventory_item_id || ', Lot Control code : ' || l_lot_code||', Lot Number : '|| l_lot_number);
611: mydebug('create_mo: Item Id : ' || l_inventory_item_id || ', Serial Control Code : ' || l_serial_control_code);