DBA Data[Home] [Help]

APPS.INV_SERIAL_NUMBER_PUB dependencies on MTL_LOT_NUMBERS

Line 1450: from mtl_lot_numbers

1446: IF nvl(p_lot_number,'!@') = '!@' THEN
1447: l_lot_exists := 0;
1448: ELSE
1449: SELECT 1 INTO l_lot_exists
1450: from mtl_lot_numbers
1451: WHERE inventory_item_id = p_inventory_item_id
1452: AND organization_id = p_organization_id
1453: AND lot_number = p_lot_number;
1454: