APPS.WMA_INV_WRAPPERS dependencies on MTL_LOT_NUMBERS

Line 27: if(x_return_status = FND_API.G_RET_STS_SUCCESS) then --lot exists in mtl_lot_numbers

23: if(l_msg_count > 1) then
24: inv_mobile_helper_functions.get_stacked_messages(x_err_msg);
25: end if;
26:
27: if(x_return_status = FND_API.G_RET_STS_SUCCESS) then --lot exists in mtl_lot_numbers
28: select expiration_date
29: into x_lot_exp
30: from mtl_lot_numbers
31: where lot_number = p_lot_number

Line 30: from mtl_lot_numbers

26:
27: if(x_return_status = FND_API.G_RET_STS_SUCCESS) then --lot exists in mtl_lot_numbers
28: select expiration_date
29: into x_lot_exp
30: from mtl_lot_numbers
31: where lot_number = p_lot_number
32: and inventory_item_id = p_inventory_item_id
33: and organization_id = p_organization_id;
34: end if;